@@ 627-660 (lines=34) @@ | ||
624 | $numFmts->registerXPathNamespace("sml", "http://schemas.openxmlformats.org/spreadsheetml/2006/main"); |
|
625 | } |
|
626 | if (!$this->_readDataOnly && $xmlStyles) { |
|
627 | foreach ($xmlStyles->cellXfs->xf as $xf) { |
|
628 | $numFmt = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; |
|
629 | ||
630 | if ($xf["numFmtId"]) { |
|
631 | if (isset($numFmts)) { |
|
632 | $tmpNumFmt = self::array_item($numFmts->xpath("sml:numFmt[@numFmtId=$xf[numFmtId]]")); |
|
633 | ||
634 | if (isset($tmpNumFmt["formatCode"])) { |
|
635 | $numFmt = (string) $tmpNumFmt["formatCode"]; |
|
636 | } |
|
637 | } |
|
638 | ||
639 | if ((int)$xf["numFmtId"] < 164) { |
|
640 | $numFmt = PHPExcel_Style_NumberFormat::builtInFormatCode((int)$xf["numFmtId"]); |
|
641 | } |
|
642 | } |
|
643 | //$numFmt = str_replace('mm', 'i', $numFmt); |
|
644 | //$numFmt = str_replace('h', 'H', $numFmt); |
|
645 | ||
646 | $style = (object) array( |
|
647 | "numFmt" => $numFmt, |
|
648 | "font" => $xmlStyles->fonts->font[intval($xf["fontId"])], |
|
649 | "fill" => $xmlStyles->fills->fill[intval($xf["fillId"])], |
|
650 | "border" => $xmlStyles->borders->border[intval($xf["borderId"])], |
|
651 | "alignment" => $xf->alignment, |
|
652 | "protection" => $xf->protection, |
|
653 | ); |
|
654 | $styles[] = $style; |
|
655 | ||
656 | // add style to cellXf collection |
|
657 | $objStyle = new PHPExcel_Style; |
|
658 | self::_readStyle($objStyle, $style); |
|
659 | $excel->addCellXf($objStyle); |
|
660 | } |
|
661 | ||
662 | foreach ($xmlStyles->cellStyleXfs->xf as $xf) { |
|
663 | $numFmt = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; |
|
@@ 662-687 (lines=26) @@ | ||
659 | $excel->addCellXf($objStyle); |
|
660 | } |
|
661 | ||
662 | foreach ($xmlStyles->cellStyleXfs->xf as $xf) { |
|
663 | $numFmt = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; |
|
664 | if ($numFmts && $xf["numFmtId"]) { |
|
665 | $tmpNumFmt = self::array_item($numFmts->xpath("sml:numFmt[@numFmtId=$xf[numFmtId]]")); |
|
666 | if (isset($tmpNumFmt["formatCode"])) { |
|
667 | $numFmt = (string) $tmpNumFmt["formatCode"]; |
|
668 | } else if ((int)$xf["numFmtId"] < 165) { |
|
669 | $numFmt = PHPExcel_Style_NumberFormat::builtInFormatCode((int)$xf["numFmtId"]); |
|
670 | } |
|
671 | } |
|
672 | ||
673 | $cellStyle = (object) array( |
|
674 | "numFmt" => $numFmt, |
|
675 | "font" => $xmlStyles->fonts->font[intval($xf["fontId"])], |
|
676 | "fill" => $xmlStyles->fills->fill[intval($xf["fillId"])], |
|
677 | "border" => $xmlStyles->borders->border[intval($xf["borderId"])], |
|
678 | "alignment" => $xf->alignment, |
|
679 | "protection" => $xf->protection, |
|
680 | ); |
|
681 | $cellStyles[] = $cellStyle; |
|
682 | ||
683 | // add style to cellStyleXf collection |
|
684 | $objStyle = new PHPExcel_Style; |
|
685 | self::_readStyle($objStyle, $cellStyle); |
|
686 | $excel->addCellStyleXf($objStyle); |
|
687 | } |
|
688 | } |
|
689 | ||
690 | $dxfs = array(); |