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

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.

    评论
    解决 无用
    打赏 举报