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?
I found this: https://phpexcel.codeplex.com/ and did a test, it works great & Excel opens the output perfectly. Excel 2016 on my Windows 10 machine to be exact, to be exact.
It looks similar to manuverhaegen's but I don't know where the class Spreadsheet/Excel/Writer.php comes from.
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.
Richard Korts
ASKER
manuverhaegen
Can you point me to where I can get the classes you are using?
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.