Click here to get back home

MySQL -> PHP -> MS Excel?

 HomeNewsGroups | Search

comp.lang.php - PHP programming language discussions 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
MySQL -> PHP -> MS Excel? me 11-25-2008
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:
show/hide quoted text

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

show/hide quoted text

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:
show/hide quoted text

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
show/hide quoted text

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

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Driving a better car - Fuelzilla.com

Cabling site for homeowners and pros alike - Cabling-Design.com

Friends:

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap
Privacy Policy