php office导出excel phpoffice/phpexcel 导出数据

一、安装 phpoffice/phpexcel

composer require phpoffice/phpexcel

二、创建对象，写入数据

$objPHPExcel = new \PHPExcel();

$excellie = ['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ'];

$data = [

['name'=>'小红','age'=>10,'sex'=>'boy'],

['name'=>'小橙','age'=>10,'sex'=>'girl'],

['name'=>'小黄','age'=>11,'sex'=>'girl'],

];

foreach ($dataas $key=>$item){

$c =$key+1;#行

foreach($item AS $k=>$v){

$letter=$excellie[$k]; # 列

$objPHPExcel->getActiveSheet()->setCellValue($letter.$c,$val);

}

}

表格样式

字体颜色：

$objPHPExcel->getActiveSheet()->getStyle("A1")->getFont()->getColor()->setRGB('fb6400');

字体大小：

$objPHPExcel->getActiveSheet()->getStyle("A1")->getFont()->setBold(true)->setSize(14);

//设置单元格宽

$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(30);

//字体加粗

$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('宋体') //字体

->setBold(true); //字体加粗

合并单元格：

$objPHPExcel->getActiveSheet()->mergeCells("A1:B1");

设置居中：

$objPHPExcel->getActiveSheet()->getStyle("A1:B1")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

三、写入本地

$objWriter=\PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel");

/*保存到本地*/

$objPHPExcel->getActiveSheet()->setTitle('列表.xls');