Click here to get back home

MySQL -> PHP -> MS Excel?

 HomeNewsGroups | Search
 comp.lang.php    Post an article   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:
> 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 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