I have been using this technique for years to generate Excel spreadsheets from a php program.
At the beginning of the php is this code:
header("Content-type: application/vnd.ms-excel; charset=UTF-8");
$fn = "excel" . date('Y-m-d_h_i') . ".xls";
header("Content-Disposition: attachment; filename=" . $fn);
Open in new window
Then I build an old fashioned HTML table with rows & columns that become the rows & columns of the spreadsheet.
If I change the line: $fn = "excel" . date('Y-m-d_h_i') . ".xls"; to $fn = "excel" . date('Y-m-d_h_i') . ".xlsx";,
will that cause it to generate an xlsx file compatible with current Excel?
Or is there a better way?
It looks similar to manuverhaegen's but I don't know where the class Spreadsheet/Excel/Writer.p
I think I will try phpExcel.
I failed to mention in my question, I really need to save it to a file on the server, not auto download. It appears phpExcel can do either.