//实例化类库$objectPHPExcel = new \PHPExcel();//选择指定的sheet$objectPHPExcel->setActiveSheetIndex(0);//冻结(锁定)表头$objectPHPExcel->getActiveSheet()->freezePane('A2');//锁定这个单元格，则该单元格所有的左边区域和上方区域都会被锁定，也就是不受滚动条的影响，像浮在那一样，这就是锁定单元格的原理。所以锁定A2就是冻结第一行了//设定水平居中$objectPHPExcel->getActiveSheet()->getStyle('A1:J1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置颜色$objectPHPExcel->getActiveSheet()->getStyle('A1:J1')->getFont()->setBold(true)->getColor()->setARGB(\PHPExcel_Style_Color::COLOR_RED);//设置水平居中$objectPHPExcel->getActiveSheet()->getStyle('A1:J1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置背景颜色$objectPHPExcel->getActiveSheet()->getStyle('A1:J1')->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('D9FFC125');//设置宽度$objectPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);//合并单元格$objectPHPExcel->getActiveSheet()->mergeCells('A1:J1');
