Outputing PHP to Excel

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.

[cc lang=”PHP”]header(“Content-type: application/vnd.ms-excel”);
header(“Content-Disposition: attachment; filename=webbased.xls”);[/cc]

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

PS you can also use formulas.


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s