下面是完整的代碼，我已經做了我的項目
$data = new Spreadsheet_Excel_Reader();
$filename = $_SESSION['filename'];
$data->read(ROOT.$filename);
$xlshead = array();
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$xlshead[$j] = trim($data->sheets[0]['cells'][1][$j]);
}
$TotalRecord = $data->sheets[0]['numRows']-1;
$row = array();
foreach($xlshead as $hkey=>$hval) {
$row['<?php echo $data->sheets[0][\'cells\'][$j+1]['.$hkey.']; ?>'] = "{".trim($hval)."}";
}
function _loadFile($filename)
{
$contents = '';
if (file_exists($filename))
{
ob_start();
require_once $filename;
$contents = ob_get_contents();
ob_end_clean();
}
return $contents;
}
$datafile = session_id();
$writedata = "";
$writedata .= str_replace(array_values($row),array_keys($row),$_SESSION['template']);
$myFile = $datafile.".php";
$fh = fopen($myFile, 'w') or die("can't open file");
fwrite($fh, $writedata);
fclose($fh);
$showdata = _loadFile("code.php");
$_SESSION['finaldata'] = $showdata;
code.php
require_once 'Excel/reader.php';
$datafile = session_id();
if(isset($_SESSION['filename'])) {
$data = new Spreadsheet_Excel_Reader();
$filename = $_SESSION['filename'];
$data->read(ROOT.$filename);
for ($j = 1; $j <= $data->sheets[0]['numRows']-1; $j++) {
include($datafile.".php");
echo '--br--';
}
}
終于在導出該檔案到excel
session_start();
$filename ="Downloaded.xls";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
$dataarr = explode("--br--",$_SESSION['finaldata']);
?>
$dataarr = explode("--br--",$_SESSION['finaldata']);
foreach($dataarr as $res) {
echo "
".htmlentities($res)."";
}
?>