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
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.