phpspreadsheet+mpdf实现导出PDF

发布：2023-11-12 10:10分类：后端程序评论：5浏览：133

安装扩展组件

```txt
composer require phpoffice/phpspreadsheet //veitool2.0版框架已预装
composer require mpdf/mpdf
```

框架内控制器业务逻辑示范：

``` 
public function pdfout()
{
	set_time_limit(0);
	$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
	$sheet=$spreadsheet->getActiveSheet();
	$sheet->setTitle('导出信息表');  //设置当前sheet的名称
	$sheet->getColumnDimension('A')->setWidth(20); //设置单元格的宽度
	$sheet->getColumnDimension('B')->setWidth(20);
	$sheet->getDefaultRowDimension()->setRowHeight(40); //设置行高
	$sheet->setCellValue('A1', 'ID')
	->setCellValue('B1', '名称');

$itemid = $this->request->get('itemid',0);
	$itemid = is_array($itemid) ? implode(',',$itemid) : $itemid;
	$rs = MD::all("itemid IN($itemid)"); //读取数据
	$total = count($rs)+1;
	foreach($rs as $k=>$r){
		$i=$k+2;
		$sheet->setCellValue('A'.$i, $r['itemid']);
		$sheet->setCellValue('B'.$i, $r['title']);
	}
	//设置单元格边框
	$sheet->getStyle('A1:B'.$total)->applyFromArray([
		'borders' => [
			'allBorders' => [
				'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
				'color' => ['argb' => '000000'],
			],
		],
	]);
	//设置自动换行、水平、垂直居中、单元格边框
	$sheet->getStyle('A1:B'.$total)
		  ->getAlignment()->setWrapText(true)
		  ->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER)
		  ->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
	//设置文件信息
	$suffix='pdf';
	$fileName='导出数据_'.date('YmdHis');
	$fileName=iconv('UTF-8','gb2312',$fileName); //针对中文名转码
	ob_end_clean();
	header('Content-Type: application/pdf');
	header('Content-Disposition: attachment;filename="'.$fileName.'.'.$suffix.'"');
	header('Cache-Control: max-age=0');
	$objWriter= \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Mpdf');
	$objWriter->save('php://output');
	exit;
}
```

此时遇到中文可能会出现乱码的情况，解决办法即是修改`phpspreadsheet`中`Mpdf`类文件，代码片段如下：

![pdf.jpg#100%](/file/upload/image/u1/20231112/655033cfbf4f7.jpg)

导出PDF mpdf

veitool1 楼
2024-01-24 15:51

@dg_ly:
导出pdf不成功，最后 $objWriter->save('php://output'); 运行出错
两个扩展必须装好 ``` composer require phpoffice/phpspreadsheet //veitool2.0版框架已预装 composer require mpdf/mpdf ```

0 回复 (0)
dg_ly2 楼
2024-01-04 08:43

导出pdf不成功，最后 $objWriter->save('php://output'); 运行出错

0 回复 (1)
wjcms3 楼
2023-12-10 10:15

很实用

0 回复 (0)
cnfox02734 楼
2023-12-06 22:43

感谢分享

0 回复 (0)
dg_ly5 楼
2023-11-12 12:09

谢谢分享！

0 回复 (0)

发布帖子

作者信息

: veitool; 等级：Lv3; 积分：9921; 真我而为 ~

phpspreadsheet+mpdf实现导出PDF

发布：2023-11-12 10:10分类：后端程序评论：5浏览：133

作者信息

最近热帖