MySQL -> PHP -> MS Excel?

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

scenario with a File -> Open; With a double click I get junk.

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

>Hi,
>you can directly use Spreadsheet Writer that can be installed via PEAR.
>Very easy to use writing binary Excel files. See
>http://pear.php.net/package/Spreadsheet_Excel_Writer
>for more details.
>Ciao,
>Matthias

> wrote:
>
>> Hi,
>> you can directly use Spreadsheet Writer that can be installed via PEAR.
>> Very easy to use writing binary Excel files. See
>> http://pear.php.net/package/Spreadsheet_Excel_Writer
>> for more details.
>> Ciao,
>> Matthias
>
>
> This kit does seem to be abandoned when you look sat it (170 bugs on
> file and none repaired in a long time). Have you used it? Does it work
> reliably for basic operations?
> Thanks,
>
>

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