phpexcel的使用---设置输出表格的样式

代码

//将查到的数据库数据导出，有样式的读出

function write($datalist){

​    $dir = dirname(__FILE__); //找出当前脚本所在路径

​    $objPHPExcel = new PHPExcel(); //实例化一个PHPExcel()对象

​    //设置表sheet信息

​    $objSheet = $objPHPExcel->getActiveSheet(); //选取当前的sheet对象

​    $objSheet->setTitle('test'); //对当前sheet对象命名

​    $objSheet->fromArray($datalist); //利用fromArray()直接一次性填充数据

​    #表头合并并加粗

​    $objPHPExcel->getActiveSheet()->mergeCells('A1:F1');//合并

​    $objPHPExcel->getActiveSheet()->setCellValue('A1','商户贴息补贴信息');//插入数据

​    $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);//加粗

​    $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);//垂直居中

​    $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//水平居中

​    //设置表头

​    $objPHPExcel->getActiveSheet()->setCellValue('A2','参考号');

​    $objPHPExcel->getActiveSheet()->setCellValue('B2','外部交易号');

​    $objPHPExcel->getActiveSheet()->setCellValue('C2','交易时间');

​    $objPHPExcel->getActiveSheet()->setCellValue('D2','商户号');

​    $objPHPExcel->getActiveSheet()->setCellValue('E2','交易金额');

​    $objPHPExcel->getActiveSheet()->setCellValue('F2','分期贴息');

​    //设置填充的样式和背景色

​    $objPHPExcel->getActiveSheet()->getStyle( 'A1:F2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);

​    $objPHPExcel->getActiveSheet()->getStyle( 'A1:F2')->getFill()->getStartColor()->setARGB('FF808080');

​    //输出

​    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007'); //设定写入excel的类型

​    $objWriter->save($dir.'/file/test.xlsx'); //保存文件

}

效果图