doq91130 2016-08-15 13:18
浏览 175
已采纳

php导出HTML TABLE到EXCEL

I got DATA generated by PHP into HTML table format and useing the following code I EXPORT to EXCEL

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="BASIC_Data.xls"');
header('Cache-Control: max-age=0');

echo "<html>";
echo "<body>";
echo "<table class='table table-striped'>";
echo "<tbody>";

echo "<tr><td>$DATA</td></tr>";

echo "</tbody>";
echo "</table>";
echo "</body>";
echo "</html>";

it was working fine for 6 months,

NOW, I went to check and I see EXCEL is generated but no DATA.

I also checked if DATA is generated and I saw no problem.

problem is here:

header('Content-Type: application/force-download');
header('Content-Disposition: attachment;filename="BASIC_Data.xls"');
header('Cache-Control: max-age=0');

I don't know what is going on. suddenly everything changed

please help

  • 写回答

1条回答 默认 最新

  • douyou7102 2016-08-15 14:02
    关注

    Simply put: You are not outputting xls(x) data, but HTML. Excel can interpret tabular data in HTML, or at least used to but the correct way would be to generate a real Excel file with a decent library like PHPExcel instead of fooling your users into thinking they're downloading an XLS file when it's just a renamed HTML file. I know, JIRA does this as well, but it's still a bad solution.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误
  • ¥199 rust编程架构设计的方案 有偿
  • ¥15 回答4f系统的像差计算
  • ¥15 java如何提取出pdf里的文字?