PHP PHPExcel\Style Borderの例

コード例 #1

ファイル: Style.php プロジェクト: kameshwariv/testexample

 /**
  * 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();
     }
 }

コード例 #2

ファイル: HTML.php プロジェクト: kameshwariv/testexample

 /**
  * 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;
 }