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@xxxxxxxxx]
Sent: 22 May 2007 12:16 PM
To: Dale Attree
Cc: php-windows@xxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxxxxxxxxxxxx>
To: <php-windows@xxxxxxxxxxxxx>
Sent: Tuesday, May 22, 2007 3:47 PM
Subject: 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@xxxxxxxxxxxxxxxxxxxxxx) or telephone (+27
11 265 4200).
This message is free of all known viruses. It has been screened for
viruses by Blockmail.
****************************************************************************
*******************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
