Richard Korts
asked on
Generating Excel in php
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:
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?
Thanks
At the beginning of the php is this code:
<?php
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);
?>
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?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
manuverhaegen
Can you point me to where I can get the classes you are using?
Thanks
Can you point me to where I can get the classes you are using?
Thanks
ASKER
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.