PHP - Creation of Excel docucuments

How to create Excel document on the fly

[ph_eze_nouz]

Hi,

I am working on a project and I need to produce an Excel version of the reporting generated by the system. I am using PHP/MySQL, and I have already a version working pretty well using \t to separated the cells and \n to start a new row.

My question is simple: How could you present the report using more style like bold text, colors and so on? Is it possible via the "\t \n" implementation? Is it possible to use XML to generate Excel document on the fly?

I saw that there is a product ($99) which convert XML documents in Excel spreadsheet... I'll be more interested to create just a tool by myself for the challenging ;) Anybody knows a way?

Thanks for your help ;)

ph_eze_nouz

[RussellC]

I don't know if this is recommended by most by here is what I do.

Put this at the beginning of the page:

header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

And then use HTML tables and format away. It works perfectly for me.

-Russell