外边框加粗:
$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->getActiveSheet()->getColumnDimension(‘A’)->setWidth(20);
换行:
$PHPExcel->getActiveSheet()->getStyle(‘A’.$hang)->getAlignment()->setWrapText(true);
字体加粗:
$PHPExcel->getActiveSheet()->getStyle(‘A1′.’:G1′)->getFont()->setBold(true);
水平居中:
$PHPExcel->getActiveSheet()->getStyle(‘A’.$hang)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
垂直居中:
$PHPExcel->getActiveSheet()->getStyle(‘G’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
打印适应A4纸:
$PHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
设置上下左右边距:
- // 设置页面边距为0.5厘米 (1英寸 = 2.54厘米)
- $margin = 1.78 / 2.54; //phpexcel 中是按英寸来计算的,所以这里换算了一下
- $marginright = 1 / 2.54; //phpexcel 中是按英寸来计算的,所以这里换算了一下
- $objPHPExcel->getActiveSheet()->getPageMargins()->->setTop($margin); //上边距
- $objPHPExcel->getActiveSheet()->getPageMargins()->->setBottom($margin); //下
- $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft($marginright); //左
- $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(marginright); //右