外边框加粗:
$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);//右
宽php边框粗细_phpexcel导出excel外边框加粗 边框细线 合并单元格 换行 居中 上边距 左边距 打印设置...