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.

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

报告相同问题?

悬赏问题

  • ¥20 iOS绕地区网络检测
  • ¥15 python验证码滑块图像识别
  • ¥15 根据背景及设计要求撰写设计报告
  • ¥15 QT6颜色选择对话框显示不完整
  • ¥20 能提供一下思路或者代码吗
  • ¥15 用twincat控制!
  • ¥15 请问一下这个运行结果是怎么来的
  • ¥15 单通道放大电路的工作原理
  • ¥30 YOLO检测微调结果p为1
  • ¥15 DS18B20内部ADC模数转换器