Page 1 of 1

is it possible to display data to excel???

Posted: Mon Mar 06, 2006 8:41 pm
by jaylin
i use these code to export data to msexcel

Code: Select all

<?
header("Content-type: application/vnd.ms-excel"); 
header("Content-type: text/html; charset=iso-8859-1; application/x-msdownload\r\n");

header("Content-Disposition: attachment; filename=extraction.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
$data = "hello\tworld";
print $data;
?>
is it possible to format the text? for example, color of the text, bgcolor of the cell, etc.

regards,

Posted: Mon Mar 06, 2006 9:27 pm
by feyd
Not like that. Spreadsheet_Excel_Writer can perform that functionality.