If you were Registered and logged in, you could reply and use other advanced thread options
Posted by Rob on November 27, 2008, 4:10 am
> I need to get some data from a MySQL database into an Excel > Spreadsheet, potentially using PHP. > What's available in PHP to help me with writing the MS-Excel file? > Thanks,
Although I couldn't recommend a specific component, I've used many of
the classes from http://www.phpclasses.org/browse/ and found them to
be reasonably good.
Rob.
Posted by Anthony Papillion on November 29, 2008, 3:49 pm
> I need to get some data from a MySQL database into an Excel > Spreadsheet, potentially using PHP. > What's available in PHP to help me with writing the MS-Excel file?
Unfortunately, there are a lot of solutions out there but none of them
don't feel like a hack and none of them are as robust as you'd
probably like. If you're on Windows, you can probably connect to
Excel from PHP via COM but I don't know of an easy/simple way to do it
on Linux. Maybe if you're open to a 2-step solution, you could write a
connector in C# using Mono then feed XML or regular text data to it
and have IT create the Excel file.
Like I said, nothing clean and robust unfortunately.
Anthony Papillion
www.messengerboy.net
www.openemrhq.com
> Spreadsheet, potentially using PHP.
> What's available in PHP to help me with writing the MS-Excel file?
> Thanks,