Steven - 2008-07-21 17:10:21 -
In reply to message 1 from Steven
Ok, is there any flaw in this approach that would leave these files hanging around?
require_once "excel.php";
$export_file = "tmp/example.xls";
$fp = fopen("xlsfile://".$export_file, "wb");
// typically this will be generated/read from a database table
$assoc = array(
array("Sales Person" => "Sam Jackson", "Q1" => "$3255", "Q2" => "$3167", "Q3" => 3245, "Q4" => 3943),
array("Sales Person" => "Jim Brown", "Q1" => "$2580", "Q2" => "$2677", "Q3" => 3225, "Q4" => 3410),
array("Sales Person" => "John Hancock", "Q1" => "$9367", "Q2" => "$9875", "Q3" => 9544, "Q4" => 10255),
);
fwrite($fp, serialize($assoc));
fclose($fp);
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=\"MMTSserialnumbers.xls\"" );
header ("Content-Description: PHP/INTERBASE Generated Data" );
readfile("xlsfile://".$export_file);
unlink("/".$export_file);