public function getDaochu(){
//数据库中查询出的数据
$data= Db::table('fwm_list')->select();
//new一个表
$objExcel = new \PHPExcel();
$objWriter = \PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
// 设置水平垂直居中
$objExcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objExcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
// 字体和样式
$objExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objExcel->getActiveSheet()->getStyle('A2:AB2')->getFont()->setBold(true);
$objExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
// 第一行、第二行的默认高度
$objExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
$objExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
//设置某一列的宽度
$objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
// 合并
$objExcel->getActiveSheet()->mergeCells('A1:E1');
$objActSheet = $objExcel->getActiveSheet(0);
$objActSheet->setTitle('防伪码表');//设置excel的标题
$objActSheet->setCellValue('A1','防伪码表');
$objActSheet->setCellValue('A2','ID');
$objActSheet->setCellValue('B2','防伪码');
$objActSheet->setCellValue('C2','分类');
$objActSheet->setCellValue('D2','添加时间');
$objActSheet->setCellValue('E2','验证次数');
//数据从第三行开始往下输出,这里是避免头信息被覆盖(根据自己的表设置更改).
$Row = 3;
foreach ( $data as $k => $v ) {
$i = $Row + $k;
$objExcel->getActiveSheet()->setCellValue('A'.$i,$v['id']);
$objExcel->getActiveSheet()->setCellValue('B'.$i,$v['fwm_content']);
$objExcel->getActiveSheet()->setCellValue('C'.$i,$v['fwm_type']);
$objExcel->getActiveSheet()->setCellValue('D'.$i,$v['fwm_addtime']);
$objExcel->getActiveSheet()->setCellValue('E'.$i,$v['fwm_state']);
}
$objExcel->setActiveSheetIndex(0);
//4、输出
$objExcel->setActiveSheetIndex();
$time=date('YmdHis');
ob_end_clean();//清除缓冲区,避免乱码
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename=防伪码$time.xls");//告诉浏览器将输出文件的名称
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
}
```
原文:https://www.1949la.com/post/56.html
ThinkPHP5.1 PHPExcel 数据导出excel
最新推荐文章于 2024-07-31 09:57:27 发布