html 模板 excel文件,阅读excel文件并放入html模板

下面是完整的代码，我已经做了我的项目

$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)."";

}

?>