PhpSpreadsheet 导出为xls的业务逻辑参考

发布：2023-08-17 15:17分类：后端程序评论：0浏览：42

这里是导出会员某些信息到Excel表：
``` 
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->getColumnDimension('C')->setWidth(20);
$sheet->getDefaultRowDimension()->setRowHeight(50); //设置行高
$sheet->setCellValue('A1', '会员帐号')
	->setCellValue('B1', '会员姓名')
	->setCellValue('C1', '手机号码')
//读取数据
$rs = (new M())->listQuery();
$total = count($rs)+1;
foreach($rs as $k=>$r){
	$i = $k + 2;
	$sheet->setCellValue('A'.$i, $r['username']."\t");
	$sheet->setCellValue('B'.$i, $r['truename']);
	$sheet->setCellValue('C'.$i, $r['mobile']);
}
//设置单元格边框
$sheet->getStyle('A1:C'.$total)->applyFromArray([
	'borders' => [
		'allBorders' => [
			'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
			'color' => ['argb' => '000000'],
		],
	],
]);
//设置自动换行、水平、垂直居中、单元格边框
$sheet->getStyle('A1:C'.$total)
	  ->getAlignment()->setWrapText(true)
	  ->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER)
	  ->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
//设置文件信息
$suffix = 'xls';
$fileName = '会员导出_'.date('YmdHis');
$fileName = iconv('UTF-8', 'gb2312', $fileName); //针对中文名转码
$type = $suffix=='xlsx' ? 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' : 'application/vnd.ms-excel';
ob_end_clean();
header('Content-Type: '.$type);
header('Content-Disposition: attachment;filename="'. $fileName .'.'. $suffix .'"');
header('Cache-Control: max-age=0');
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xls($spreadsheet);
$writer->save('php://output'); //$writer->save('hello world.xls');
exit;
```

PhpSpreadsheet 导出Excel

暂无回复！

发布帖子

作者信息

: haohao; 等级：Lv2; 积分：1056; 这家伙很懒，什么都没写呢~

PhpSpreadsheet 导出为xls的业务逻辑参考

发布：2023-08-17 15:17分类：后端程序评论：0浏览：42

作者信息

最近热帖