两种方法可以实现,比如你要在单元格A1和B2两个单元格画斜线。
第一种方法:
$objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->setDiagonalDirection(\PHPExcel_Style_Borders::DIAGONAL_DOWN );
$objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getDiagonal()-> setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
第二种方法:
$PHPExcel -> getStyle('B2') -> getBorders()->applyFromArray(
array('diagonal' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array( 'rgb' => '808080' ), ),
'diagonaldirection' => PHPExcel_Style_Borders::DIAGONAL_DOWN )
);
PHPExcelStyleBorders::DIAGONALDOWN "从左上角到右下角"
PHPExcelStyleBorders::DIAGONALUP "从右上角到左下角"
PHPExcelStyleBorders::DIAGONAL_BOTH "交叉斜线边框"
2.getDiagonal() 函数获取斜线边框,可用于设置边框的样式。
第一种方法:
$objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->setDiagonalDirection(\PHPExcel_Style_Borders::DIAGONAL_DOWN );
$objPHPExcel->getActiveSheet()->getStyle('A1')->getBorders()->getDiagonal()-> setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
第二种方法:
$PHPExcel -> getStyle('B2') -> getBorders()->applyFromArray(
array('diagonal' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array( 'rgb' => '808080' ), ),
'diagonaldirection' => PHPExcel_Style_Borders::DIAGONAL_DOWN )
);
总结:
PHPExcelStyleBorders::DIAGONALDOWN "从左上角到右下角"
PHPExcelStyleBorders::DIAGONALUP "从右上角到左下角"
PHPExcelStyleBorders::DIAGONAL_BOTH "交叉斜线边框"
2.getDiagonal() 函数获取斜线边框,可用于设置边框的样式。
转自: