php读取excel文件示例分享(更新修改excel)_php实例

//模板存放目录<BR>$dir = $DOCUMENT_ROOT.'/backoffice/admin/oemcheck/';<br><br>$templateName = '1.xlsx';<BR>$outputFileName = '模板.xlsx';<BR>$txt='test';<br><br>//实例化Excel读取类<BR>$PHPReader = new PHPExcel_Reader_Excel2007();<BR>if(!$PHPReader->canRead($dir.$templateName)){<BR> $PHPReader = new PHPExcel_Reader_Excel5();<BR> if(!$PHPReader->canRead($dir.$templateName)){<BR>  echo '无法识别的Excel文件！'<b style="color:transparent">本文来源gao@!dai!ma.com搞$$代^@码!网!</b><strong>搞gaodaima代码</strong>;<BR>  return false;<BR> }<BR>}<BR>//读取Excel<BR>$PHPExcel = $PHPReader->load($dir.$templateName);<BR>//读取工作表1<BR>$currentSheet = $PHPExcel->getSheet(0);<br><br>$currentSheet->setCellValue('B13',iconv('gbk','utf-8',$txt));//表头赋值//<BR>//实例化Excel写入类<BR>$PHPWriter = new PHPExcel_Writer_Excel2007($PHPExcel);<BR>ob_start();<BR>header("Content-Type: application/force-download");<BR>header("Content-Type: application/octet-stream");<BR>header("Content-Type: application/download");<BR>header('Content-Disposition:attachment;filename="' .$outputFileName. '"');//输出模板名称<BR>header("Content-Transfer-Encoding: binary");<BR>header("Last-Modified:".gmdate("D, d M Y H:i:s")." GMT");<BR>header('Pragma: public');<BR>header('Expires: 30');<BR>header('Cache-Control: public');<BR>$PHPWriter->save('php://output');<BR>

喜欢 (0)赏

[搞代码]

分享 (0)