/** * Write BorderPr * * @param \PHPExcel\Shared\XMLWriter $objWriter XML Writer * @param string $pName Element name * @param \PHPExcel\Style\Border $pBorder Border style * @throws \PHPExcel\Writer\Exception */ private function writeBorderPr(\PHPExcel\Shared\XMLWriter $objWriter = null, $pName = 'left', \PHPExcel\Style\Border $pBorder = null) { // Write BorderPr if ($pBorder->getBorderStyle() != \PHPExcel\Style\Border::BORDER_NONE) { $objWriter->startElement($pName); $objWriter->writeAttribute('style', $pBorder->getBorderStyle()); // color $objWriter->startElement('color'); $objWriter->writeAttribute('rgb', $pBorder->getColor()->getARGB()); $objWriter->endElement(); $objWriter->endElement(); } }
/** * Create CSS style (\PHPExcel\Style\Border) * * @param \PHPExcel\Style\Border $pStyle \PHPExcel\Style\Border * @return string */ private function createCSSStyleBorder(\PHPExcel\Style\Border $pStyle) { // Create CSS // $css = $this->mapBorderStyle($pStyle->getBorderStyle()) . ' #' . $pStyle->getColor()->getRGB(); // Create CSS - add !important to non-none border styles for merged cells $borderStyle = $this->mapBorderStyle($pStyle->getBorderStyle()); $css = $borderStyle . ' #' . $pStyle->getColor()->getRGB() . ($borderStyle == 'none' ? '' : ' !important'); return $css; }