PHPExcel笔记, mpdf导出

<h2 style="text-align: left; padding-bottom: 0px; widows: 1; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; margin: 20px 0px 10px; padding-left: 0px; letter-spacing: normal; padding-right: 0px; font: 600 20px/36px 'Microsoft YaHei',Verdana,sans-serif,宋体; white-space: normal; color: rgb(51,51,51); word-spacing: 0px; padding-top: 0px; -webkit-text-stroke-width: 0px">PHPexcel常用处理

导入类库

require 'PHPExcel/Classes/PHPExcel.php';
require 'PHPExcel/Classes/PHPExcel/Writer/Excel5.php'; //非07格式的写出类

基础属性设定

$objPHPExcel = \PHPExcel_IOFactory::load('a.xls'); //读入指定excel文件
$objPHPExcel->setActiveSheetIndex(0); //指定活动工作表
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('宋体');
$objPHPExcel->getProperties()->setTitle('xxx');

单元格编辑

$objPHPExcel->getActiveSheet()->setCellValue('A3','xxx'); //设定A3单元格值为xxx

单元格绘图

$objDrawing = new \PHPExcel_Worksheet_Drawing();
$objDrawing->setPath('a.jpg'); //指定图片路径。若要远程图片需PHPExcel/Classes/PHPExcel/Worksheet/Drawing.PHP:106处file_exists换成file_get_contents
$objDrawing->setCoordinates('A4'); //指定在A4单元格绘图
$objDrawing->setName('Photo');
$objDrawing->setDescription('Photo');
$objDrawing->setHeight(120);
$objDrawing->setWidth(100);
$objDrawing->setOffsetX(7);
$objDrawing->setOffsetY(7);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

excel文件浏览器下载导出

$filename='a.xls';
$encoded_filename = rawurlencode($filename);
$ua = $_SERVER["HTTP_USER_AGENT"];
header('Content-type: application/vnd.ms-excel');
if (preg_match("/MSIE/",$ua) || preg_match("/Trident\/7.0/",$ua) || preg_match("/Edge/",$ua)) {
header('Content-Disposition: attachment; filename="' . $encoded_filename . '"');
} else if (preg_match("/Firefox/",$ua)) {
header("Content-Disposition: attachment; filename*=\"utf8''" . $filename . '"');
} else {
header('Content-Disposition: attachment; filename="' . $filename . '"');
}
header("Pragma:no-cache");
header("Expires:0");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');
$objWriter->save('PHP://output');

excel文件html显示(可用于调试)

$objWriter = new \PHPExcel_Writer_HTML($objPHPExcel);
$objWriter->save('PHP://output');

<h2 style="text-align: left; padding-bottom: 0px; widows: 1; text-transform: none; background-color: rgb(255,51); word-spacing: 0px; padding-top: 0px; -webkit-text-stroke-width: 0px">利用mpdf库从PHPexcel导出pdf文件
<div class="jb51code">
<pre class="brush:php;">
$filename='a.pdf';
$encoded_filename = rawurlencode($filename);
$rendererName = \PHPExcel_Settings::PDF_RENDERER_MPDF; //指定通过mpdf类库导出pdf文件
$rendererLibraryPath = 'PHPExcel/MPDF57'; //指定你下载的mpdf类库路径
if (!\PHPExcel_Settings::setPdfRenderer(
$rendererName,$rendererLibraryPath
)) {
die(
'Please set the $rendererName and $rendererLibraryPath values' .
PHP_EOL .
' as appropriate for your directory structure'
);
}
header('Content-type: application/pdf');
if (preg_match("/MSIE/",$ua)) {
header("Content-Disposition: attachment; filename*=\"utf8''" . $file_name . '"');
} else {
header('Content-Disposition: attachment; filename="' . $file_name . '"');
}
header("Pragma:no-cache");
header("Expires:0");
$objWriter = new \PHPExcel_Writer_PDF($objPHPExcel);
$objWriter->setPreCalculateFormulas(false);
$objWriter->save('PHP://output');

##############################

pdf导出失败的一些错误 解决方法

##############################

1 pdf中文乱码问题

PHPExcel/Classes/PHPExcel/Writer/PDF/mPDF.PHP:105处加两行设定：
$pdf->useAdobeCJK = true;
$pdf->SetAutoFont(AUTOFONT_ALL);

2 类库里面多处preg_replace调用使用了元字符e，而部分低版本PHP 不支持正则表达式e元字符

e元字符的不当使用并导致pdf报错的触发点在类库里面大概有五六处吧，
由于e元字符是一个shell下的子进程PHP 调用，所以报错信息不会反馈到当前PHP进程中，故即便你配置了错误打印到屏幕，页面也不会显示报错信息，必须查看PHP报错日志
查看PHP报错日志，把提示的preg_replace中元字符e的调用替换为preg_replace_callback形式的调用

3 部分版本PHPexcel类库有单元格样式判断错误

lib/PHPExcel/Classes/PHPExcel/Writer/HTML.PHP:1236处加个if判断
if (!$this->_useInlineCss) {
$cssClass .= ' style' . $pSheet->getCell($endCellCoord)->getXfIndex();