RE: [PHP] Excel Spreadsheets and PHP
| From: | Ashley Sheridan | Date: | Fri, 19 Feb 2010 20:48:08 +0000 |
| Subject: | RE: [PHP] Excel Spreadsheets and PHP | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302227@lists.php.net to get a copy of this message | ||
On Fri, 2010-02-19 at 15:36 -0500, Bob McConnell 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
>
I believe there are pear classes to output these files, and the new xlsx
format is XML-based so shouldnt be too difficult to output something
simple. Also, the ods format is well documented, and again should be
very easy to output to.
Thanks,
Ash
http://www.ashleysheridan.co.uk