php更新修改excel中的内容实例代码
前端之家收集整理的这篇文章主要介绍了
php更新修改excel中的内容实例代码，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
<div class="codetitle"><a style="CURSOR: pointer" data="88853" class="copybut" id="copybut88853" onclick="doCopy('code88853')"> 代码如下:
<div class="codebody" id="code88853">
//模板存放目录
$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');
