I don't know if this is the best way or not, but I just use the
following function to send Excel headers, then just create your page as
a normal HTML table. Excel will take the HTML table and create a
spreadsheet with it.
##############################################
#
# Creates headers to send MS Excel file
#
##############################################
function COM_ExcelHeader($filename = "download")
{
//MS Excel Headers
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=" . $filename .
".xls");
}
---John Holmes...
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 24, 2002 5:11 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] using header() to display info in excel
>
> Hey,
>
> I am looking to read information from a database and when you click a
link
> all of those arrays will be displayed in excel using header();. I
have
> heard
> there are lots of commands in cgi but I don't know cgi and I am
wondering
> if
> it is still possible with php. I would also like info on reading
> information
> from excel to a mysql database using php.
>
> Thanks a lot,
> Kevin
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
