复制代码 代码如下:

//模板存放目录
$dir = $DOCUMENT_ROOT.\'/backoffice/admin/oemcheck/\';

$templateName = \'1.xlsx\';
$outputFileName = \'模板.xlsx\';
$txt=\'test\';

//实例化Excel读取类
$PHPReader = new PHPExcel_Reader_Excel2007();
if(!$PHPReader->canRead($dir.$templateName)){
 $PHPReader = new PHPExcel_Reader_Excel5();
 if(!$PHPReader->canRead($dir.$templateName)){
  echo \'无法识别的Excel文件！\';
  return false;
 }
}
//读取Excel
$PHPExcel = $PHPReader->load($dir.$templateName);
//读取工作表1
$currentSheet = $PHPExcel->getSheet(0);

$currentSheet->setCellValue(\'B13\',iconv(\'gbk\',\'utf-8\',$txt));//表头赋值//
//实例化Excel写入类
$PHPWriter = new PHPExcel_Writer_Excel2007($PHPExcel);
ob_start();
header(\"Content-Type: application/force-download\");
header(\"Content-Type: application/octet-stream\");
header(\"Content-Type: application/download\");
header(\'Content-Disposition:attachment;filename=\"\' .$outputFileName. \'\"\');//输出模板名称
header(\"Content-Transfer-Encoding: binary\");
header(\"Last-Modified:\".gmdate(\"D, d M Y H:i:s\").\" GMT\");
header(\'Pragma: public\');
header(\'Expires: 30\');
header(\'Cache-Control: public\');
$PHPWriter->save(\'php://output\');