设置全部边框方式
$objPHPExcel->getActiveSheet()->getStyle('A' . $i . ':O' .($i+1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
通过分析PHPEXCEL库代码发现可指定设置4个方向的边框
$this->getLeft()->applyFromArray($pStyles['allborders']); $this->getRight()->applyFromArray($pStyles['allborders']); $this->getTop()->applyFromArray($pStyles['allborders']); $this->getBottom()->applyFromArray($pStyles['allborders']);
最终得到设置方法:
$objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_NONE); $objPHPExcel->getActiveSheet()->getStyle('C' . ($i+1))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_NONE); $objPHPExcel->getActiveSheet()->getStyle('G' . $i)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_NONE); $objPHPExcel->getActiveSheet()->getStyle('G' . ($i+1))->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_NONE);
最终实现的效果如下:
如果本文对你有帮助,欢迎打赏本站