如何使用PHPExcel将HTML表格导出到Excel?
因为在不同的浏览器中很难处理不同的标准，所以我放弃了尝试使用js或jQuery导出html表的尝试.我想知道是否可以将html中的表发布回服务器，并在服务器上生成一个.xls文件供用户下载.
Because it is hard to deal with different standards among different browsers, I give up trying to export html table using js or jQuery. I wonder if I can POST the table in html back to server and generate an .xls file on the server for user to download.
现在在使用PHPExcel的服务器端，我的代码如下:
Now on the server side using PHPExcel, my code is like this:
$filename = "DownloadReport";
$table = $_POST['table'];
ini_set('zlib.output_compression','Off');
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
//the folowing two lines make sure it is saved as a xls file
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
$objReader = PHPExcel_IOFactory::createReader('HTML');
$objPHPExcel = $objReader->load($table);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
问题是我无法直接加载html表.我该如何处理?
The problem is I cannot load html table directly. How can I deal with that?
还有一个问题是，当我在php中设置标题时，单击该按钮时文件未下载.实际上，我可以查看POST响应的Header的所有属性，以及响应的内容(在FireBug中)，这些属性都是正确的.
And one more question is that as I set the headers in php, the file is not downloading when I click the button. Actually I can view all the attributes of Header of the POST response, and also the content of response(in FireBug), which are all correct.
要将内容直接放入$objPHPExcel，您需要创建一个工作表，然后逐个单元格设置值，这不是您想要的.
To put contents directly into $objPHPExcel you would need to create a worksheet and then set values cell by cell, which is not what you want.
要插入整个HTML表，必须从HTMLReader
To insert a whole HTML table, you must read it from an HTMLReader
在Writer下面的代码中，将用于将内容输出到文件中
In the code below the Writer will be used to output the content to file
$filename = "DownloadReport";
$table = $_POST['table'];
// save $table inside temporary file that will be deleted later
$tmpfile = tempnam(sys_get_temp_dir(), 'html');
file_put_contents($tmpfile, $table);
// insert $table into $objPHPExcel's Active Sheet through $excelHTMLReader
$objPHPExcel = new PHPExcel();
$excelHTMLReader = PHPExcel_IOFactory::createReader('HTML');
$excelHTMLReader->loadIntoExisting($tmpfile, $objPHPExcel);
$objPHPExcel->getActiveSheet()->setTitle('any name you want'); // Change sheet's title if you want
unlink($tmpfile); // delete temporary file because it isn't needed anymore
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // header for .xlxs file
header('Content-Disposition: attachment;filename='.$filename); // specify the download file name
header('Cache-Control: max-age=0');
// Creates a writer to output the $objPHPExcel's content
$writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$writer->save('php://output');
exit;