Re: export data to a ms excel file using php
| From: | Ashley Sheridan | Date: | Wed, 22 Oct 2008 22:44:59 +0000 |
| Subject: | Re: export data to a ms excel file using php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282305@lists.php.net to get a copy of this message | ||
On Wed, 2008-10-22 at 22:04 +0000, ceo@l-i-e.com wrote:
> The easiest solution is to output CSV, and use the Content-type to force it to be eXcel.
>
>
>
> Excel will suck the CSV in just fine, with minimal hassle by the user.
>
>
>
> It also makes a file that is useful for many more applications, not just Excel.
>
I don't think this is right for the situation, as you'll see if you
re-read the original question. He wants to preserve things like column
widths, and I know for a fact that Excel will not automatically expand
all columns to best fit the data, and CSV is a pure data format, so will
not do here.
Ash
www.ashleysheridan.co.uk