|
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
> 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
show/hide quoted text
>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:
show/hide quoted text
>
>> 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 show/hide quoted text
>>>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 |
|
XML Sitemap
> Spreadsheet, potentially using PHP.
>
> What's available in PHP to help me with writing the MS-Excel file?
>
> Thanks,
>