03 Jan 2010

Outputing PHP to Excel

Main No Comments

A few people have recently asked me about outputting data to Excel. This is a very simple thing to do from PHP with two lines of code.

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=webbased.xls");

After this just output your data to a table which you can style using in-line CSS.

PS you can also use formulas.


No Responses to “Outputing PHP to Excel”

Leave a Reply