外边框加粗:
$styleArray2 = array(
‘borders’ => array(
‘outline’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THICK,//边框是粗的
),
),
);
$PHPExcel->getActiveSheet()->getStyle(‘A1:G1’)->applyFromArray($styleArray);
边框细线:
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN, //细边框
//’color’ => array(‘argb’ => ‘FFFF0000’),
),
),
);
$PHPExcel->getActiveSheet()->getStyle(‘A1:G1’)->applyFromArray($styleArray);
合并单元格:
$PHPExcel->getActiveSheet()->mergeCells(“B1:G1”);
给单元格设置值:
$PHPExcel->getActiveSheet()->setCellValue(‘A1’, ‘供应商名称:’);
设置表格宽度:
$PHPExcel->getActiveShe