Page 1 of 1

Exporting to Excel - what method are you using

Posted: Fri Feb 23, 2007 2:53 pm
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.

Posted: Fri Feb 23, 2007 3:20 pm
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.

Posted: Fri Feb 23, 2007 7:31 pm
by feyd
Have you tried the PEAR Excel Writer?

Posted: Sun Feb 25, 2007 9:18 pm
by bluesman333
the PEAR Excel Writer looks like it could work for me.

Thanks