脚本宝典收集整理的这篇文章主要介绍了如何使用PHPExcel将html表导出到Excel?,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
$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;@H_502_1@问题是我无法直接加载html表.我该怎么处理? @H_502_1@还有一个问题是,当我在PHP中设置标题时,单击按钮时文件不会下载.实际上,我可以查看POST响应的Header的所有属性,以及响应的内容(在FireBug中),这些都是正确的.
@H_502_1@在下面的代码中,Writer将用于将内容输出到文件
$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;
以上是脚本宝典为你收集整理的如何使用PHPExcel将html表导出到Excel?全部内容,希望文章能够帮你解决如何使用PHPExcel将html表导出到Excel?所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。