phpexcel导出excel外边框加粗，边框细线，合并单元格，换行，居中，上边距，左边距，打印设置

外边框加粗：

$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);

设置上下左右边距：

1. // 设置页面边距为0.5厘米 (1英寸 = 2.54厘米)
2. $margin = 1.78 / 2.54;   //phpexcel 中是按英寸来计算的,所以这里换算了一下
3. $marginright = 1 / 2.54;   //phpexcel 中是按英寸来计算的,所以这里换算了一下
4. $objPHPExcel->getActiveSheet()->getPageMargins()->->setTop($margin);       //上边距
5. $objPHPExcel->getActiveSheet()->getPageMargins()->->setBottom($margin); //下
6. $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft($marginright);      //左
7. $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(marginright);    //右