Re: [PHP] Excel Spreadsheets and PHP

On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell <[email protected]> wrote:
> From: Ian Robertson
>
>> What are you using, if anything, to create Excel spreadsheets with
> PHP?
>>
>
> Output CSV files with the correct MIME type. MS-Windows will open them
> in Excel by default in both IE and Firefox.
>
> Unfortunately, this happens even if you have Open Office installed and
> would prefer to use that.
>
> Bob McConnell
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

If you need more control over formatting, formulas, etc., there is an
XML format that Microsoft supports.

http://msdn.microsoft.com/en-us/library/aa140066%28office.10%29.aspx

Then you can use DOM in PHP to build what you need.

Andrew