Re: PHP generated Excel Spreadsheets

There is another simple "crude" way of accomplishing the same task which works for me. Example: <?php $xls = ' <table> <tr> <td>column 1</td><td>column 2</td> </tr> </table>'; header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename="export.xls"'); header('Cache-Control: max-age=5, must-revalidate'); header('Pragma: public'); print $xls; ?> Dale Attree wrote:

I think csv is the way I will have to go. I think Microsoft may have migrated from the BIFF5 standard with Excel 2007 and that is what is causing this problem. Unfortunately, the script is database driven and also a company report, so I am unable to share it. -----Original Message----- From: bedul [mailto:landavia81@gmail.com] Sent: 22 May 2007 12:16 PM To: Dale Attree Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] PHP generated Excel Spreadsheets nope.. there were something strange with those excel 2007.. but i always use csv instead excel 2007.. well.. can u share us your script related to above? ----- Original Message ----- From: "Dale Attree" <dale@jacklinenterprises.com> To: <php-windows@lists.php.net> Sent: Tuesday, May 22, 2007 3:47 PM Subject: [PHP-WIN] PHP generated Excel Spreadsheets

Using PEAR :: Spreadsheet_Excel_Writer I am having compatibility issues with Excel 2007. Has anyone else experienced issues and got solutions? ________________________ Dale Attree PHP Developer Jacklin Enterprises tel: +27 11 265 4282 mobile: +27 83 407 2911 fax: +27 11 314 2984

**************************************************************************** *******************

The information contained in this e-mail is confidential and may be

subject to legal privilege.

Access to this e-mail by anyone other than the intended recipient is

unauthorised.

If you are not the intended recipient you must not use, copy, distribute

or disclose the e-mail or any part of its contents or take any action in reliance on it. If you have received this e-mail in error, please notify us immediately by e-mail (postmaster@jacklinenterprises.com) or telephone (+27 11 265 4200).

This message is free of all known viruses. It has been screened for

viruses by Blockmail. **************************************************************************** *******************