phpexcel下载

发布于12月20日

你好我是phpexcel的新手，

我试图创建一个"导出按钮"在一个页面上，将给用户一个"弹出"与他想要的Excel，我刚刚创建.

现在，在创建表之后，我执行以下操作:

$objXLS->getActiveSheet()->getColumnDimension("A")->setAutoSize(true);
$objXLS->getActiveSheet()->getColumnDimension("B")->setAutoSize(true);

$objXLS->getActiveSheet()->setTitle('Test Stats');

$objXLS->setActiveSheetIndex(0);

$objWriter = PHPExcel_IOFactory::createWriter($objXLS, 'Excel5');
$objWriter->save(__DIR__."/test1.xls");

但这会把它保存到我的服务器上

非常感谢.

推荐答案

Instead of saving it to a file, save it to php://output^Docs:

$objWriter->save('php://output');

这将按原样发送到浏览器.

You want to add some headers^Docs first, like it's common with file downloads, so the browser knows which type that file is and how it should be named (the filename):

// We'll be outputting an excel file
header('Content-type: application/vnd.ms-excel');

// It will be called file.xls
header('Content-Disposition: attachment; filename="file.xls"');

// Write file to the browser
$objWriter->save('php://output');

首先做标题，然后保存.有关excel标题，请参见以下问题:Setting mime type for excel document.