Exporting to Excel - what method are you using

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
User avatar
bluesman333
Forum Commoner
Posts: 52
Joined: Wed Dec 31, 2003 9:47 am

Exporting to Excel - what method are you using

Post by bluesman333 »

For most of the reports I do I give the user a CSV file. But there is no formatting in the file. I've had some success with COM functions, but it is inconsistent and will not work on a UNIX based server.

My main goal is to be able to give users formatted data. A spreadsheet would be an ideal format as the user will be able to manipulate the data, but I am willing to here any other simple solutions that you have experience with.

Thanks in advance for your input.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

We have a proper Excel/Workbook class at work. However, I believe we may not be able redistribute it for licensing reasons (it did used to be free... but now it's not). I'm afraid I won't be logging on to my work's machines until Monday but I'll check the license then.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Have you tried the PEAR Excel Writer?
User avatar
bluesman333
Forum Commoner
Posts: 52
Joined: Wed Dec 31, 2003 9:47 am

Post by bluesman333 »

the PEAR Excel Writer looks like it could work for me.

Thanks
Post Reply