MySQL -> PHP -> MS Excel?

Posted by me on November 25, 2008, 1:49 pm

Please log in for more thread options

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,

Posted by Luuk on November 25, 2008, 1:56 pm

Please log in for more thread options

me schreef:

> 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,

most simple would be (i think) to create a CSV file...

Posted by me on November 25, 2008, 2:15 pm

Please log in for more thread options

>me schreef:

>> 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,

>most simple would be (i think) to create a CSV file...

That was my preferred choice too, but the customer wants it directly
in MS-Excel format - they don't want to have to do an import of any
sort.

Posted by Luuk on November 25, 2008, 3:46 pm

Please log in for more thread options

me schreef:

>> me schreef:

>>> 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,

>>>

>> most simple would be (i think) to create a CSV file...

> That was my preferred choice too, but the customer wants it directly

> in MS-Excel format - they don't want to have to do an import of any

> sort.

and you asked them what they think is the benefit of it being in
Excel-format over it being in CSV-format?

If its in CSV-format you know for sure that you still can access your
data in 3 years time...

If its in Excel-format, you might have to re-install an ancient version
of Excel to retreive your information....

Posted by Surfer! on November 25, 2008, 4:11 pm

Please log in for more thread options

>>>most simple would be (i think) to create a CSV file...

>> That was my preferred choice too, but the customer wants it directly

>> in MS-Excel format - they don't want to have to do an import of any

>> sort.

>Give the CSV file a .xls extension so it gets the right desktop icon,

>and they'll probably never notice the difference. :-)

My PC uses the Excel icon for CSV files as well, but your idea is a good
one. The only problem I can think of is if there is data where leading
zeros are significant - I've tried several times to create a CSV where
they get retained but without success. And of course if the spreadsheet
needs several sheets and/or formulae.

--
Surfer!
Email to: ramwater at uk2 dot net

Similar Threads	Posted
Excel to MySQL through PHP?	April 1, 2006, 4:27 pm
MySQL as Excel?	February 3, 2009, 6:50 pm
Export mysql data to excel?	March 10, 2008, 6:03 am
Exporting MySQL Data to Excel using PHP	January 5, 2009, 10:18 am
Import Excel file into MySQL database	September 3, 2004, 2:27 am
Reading Excel to MySql or Comma delimited ...	June 14, 2006, 6:44 pm
PHP (mysql) to Excel, Word and PDF and other report formats	May 2, 2009, 4:52 am
PHP / MySQL to Excel - good library recommendation?	May 18, 2009, 7:24 am
uploading special characters from excel to mysql and php binary/Image	June 17, 2008, 10:47 am
PHP COM Excel Obj	May 31, 2006, 7:06 pm