Download Webpage Report in Excel Format- Urgent

[ahmurad]

Dear Brothers,

I have created a report by using php and mysql. This report is changed according to various condition and gives output on the page. Now I need to add a download button on the page so that if anybody click on the download button the report displaying in the page will be downloaded in Excell format.

That means the report which is generated in the web page need to download in excel format.

That is very very urgent task for me.Please help me as early as possible. I am awaiting forward to your valued solution.

Regards,
ahmurad

[Atli]

Hi.

Unfortunately, Excel uses a proprietor M$ format, so PHP doesn't have any native support for it. (M$ would probably sue if they tried.)

You could try exporting it into a CSV or a XML file. I'm sure Excel is able to read those.
But that may not support any decent formatting.

The only alternative I see would be to study the XML format that Excel uses and have your PHP output something like that, but I wouldn't expect something like that to happen over night.

[pbmods]

Heya, Ahmurad.

Try the Excel Writer class (http://www.phpclasses.org/browse/package/2037.html).