Question

thinkphp调用phpexcel导出excel

$objWriter->save('php://output'); //文件通过浏览器下载

这句执行不了，如果改成$objWriter->save('test.xls');这样会下载到项目的根目录下，求大神指点

Answer 1

加上header 头

            $outputFileName = "新款表".date("Y-m-d H:i:s",time()).".xls"; 
            header("Content-Type: application/force-download");  
            header("Content-Type: application/octet-stream");  
            header("Content-Type: application/download");  
            header('Content-Disposition:inline;filename="'.$outputFileName.'"');  
            header("Content-Transfer-Encoding: binary");  
            header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");  
            header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");  
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0");  
            header("Pragma: no-cache");              
            $objWriter->save('php://output'); 
            exit;

追问

加上去也不行

追答

            ob_end_clean();
            $outputFileName = "新款表".date("Y-m-d H:i:s",time()).".xls"; 
            header("Content-Type: application/force-download");  
            header("Content-Type: application/octet-stream");  
            header("Content-Type: application/download");  
            header('Content-Disposition:inline;filename="'.$outputFileName.'"');  
            header("Content-Transfer-Encoding: binary");  
            header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");  
            header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");  
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0");  
            header("Pragma: no-cache");              
            $objWriter->save('php://output'); 
            exit;