//设置填充的样式和背景色
$objPHPExcel->getActiveSheet()->getStyle( 'A1:AU1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle( 'A1:AU1')->getFill()->getStartColor()->setARGB('FFFF00');
$styleThinBlackBorderOutline = array(
'borders' => array(
'allborders' => array( //设置全部边框
'style' => \PHPExcel_Style_Border::BORDER_THIN //粗的是thick
),
),
);
$objPHPExcel->getActiveSheet()->getStyle( 'A1:AU1')->applyFromArray($styleThinBlackBorderOutline);
foreach ($cellKey as $key=>$val){
if($key<47){
//设置单元格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension($val)->setWidth(30);#设置单元格宽度
//换行
$objPHPExcel->getActiveSheet()->getStyle($val.'1')->getAlignment()->setWrapText(true);
}
}
//必须双引号
$objSheet->setCellValue($cellKey[0] . '1', "*******"."\n"."必填");
phpexcel 小技巧的相关教程结束。
