php导入excel生成pdf

准备工作:

composer require mpdf/mpdf

composer require phpoffice/phpexcel

$objReader = \PHPExcel_IOFactory::createReader("Excel5");
$objPHPExcel = $objReader->load("2.xls");
\PHPExcel_Settings::setPdfRendererName('mPDF');
$PdfPath = realpath($_SERVER['DOCUMENT_ROOT']. '/../vendor/mpdf/mpdf/src');
\PHPExcel_Settings::setPdfRendererPath($PdfPath);

//Write Excel
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
$objWriter->save('testing.pdf');

注意：前两行代码读取只能读取 .xls文件，要读取 .xlsx文件第一行第二行修改如下代码：

$objReader = \PHPExcel_IOFactory::createReader("Excel2007");
$objPHPExcel = $objReader->load("2.xlsx");