Re: Excel Spreadsheets and PHP
| From: | Andrew Ballard | Date: | Fri, 19 Feb 2010 20:53:16 +0000 |
| Subject: | Re: Excel Spreadsheets and PHP | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302228@lists.php.net to get a copy of this message | ||
On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell <rvm@cbord.com> 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