一、安裝 phpoffice/phpexcel

composer require phpoffice/phpexcel

二、創(chuàng)建對象，寫入數(shù)據(jù)

$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 ($data?as $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');

字體大?。?/p>

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

//設(shè)置單元格寬

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

//字體加粗

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

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

合并單元格：

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

設(shè)置居中：

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

三、寫入本地

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

/*保存到本地*/

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