导出到Excel的HTML表在Chrome上显示为空

Question

I have a php script which generates an html table and exports to excel. This script is used in several places in my company's internal software. I just started getting reports that it isn't working and found that when used in Chrome -- and only Chrome -- it produces an empty file. Does anyone know what could be causing it? Did Chrome start ignoring the Excel header, and if so, is there a different header to use?

I am using the following headers:
header("Content-Type: application/vnd.ms-excel; charset=utf-8"); header("Content-Disposition: attachment; filename=${_POST['filename']}.xls;");

Answer 1

If you can get away with using a .csv, this works in Chrome and will open in excel:

header('Cache-control: private');
header("Content-type: text/x-csv");
header("Content-Disposition: attachment; filename=" . $_POST['filename'] . ".csv");