I'm trying to hide the excel grid on the screen view by making all borders in the worksheet white. I can't figure out how to get it working though.
My attempts so far:
$objPHPExcel->getDefaultStyle()->applyFromArray(array(
'borders' => array(
'allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => PHPExcel_Style_Color::COLOR_WHITE)
)
)
));
and
$objPHPExcel->getDefaultStyle()->applyFromArray(array(
'borders' => array(
'top' => array('style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => PHPExcel_Style_Color::COLOR_WHITE)
),
'bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => PHPExcel_Style_Color::COLOR_WHITE)
),
'left' => array('style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => PHPExcel_Style_Color::COLOR_WHITE)
),
'right' => array('style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => PHPExcel_Style_Color::COLOR_WHITE)
)
)
));
I can't see where I'm going wrong.
Thanks in advance for any help offered.