See Release Notes
Long Term Support Release
<?php namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx; use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;> use SimpleXMLElement;class SheetViewOptions extends BaseParserClass {> /** @var Worksheet */private $worksheet;> /** @var ?SimpleXMLElement */private $worksheetXml;< public function __construct(Worksheet $workSheet, \SimpleXMLElement $worksheetXml = null)> public function __construct(Worksheet $workSheet, ?SimpleXMLElement $worksheetXml = null){ $this->worksheet = $workSheet; $this->worksheetXml = $worksheetXml; }< /** < * @param bool $readDataOnly < */ < public function load($readDataOnly = false)> public function load(bool $readDataOnly, Styles $styleReader): void{ if ($this->worksheetXml === null) { return; } if (isset($this->worksheetXml->sheetPr)) {< $this->tabColor($this->worksheetXml->sheetPr); < $this->codeName($this->worksheetXml->sheetPr); < $this->outlines($this->worksheetXml->sheetPr); < $this->pageSetup($this->worksheetXml->sheetPr);> $sheetPr = $this->worksheetXml->sheetPr; > $this->tabColor($sheetPr, $styleReader); > $this->codeName($sheetPr); > $this->outlines($sheetPr); > $this->pageSetup($sheetPr);} if (isset($this->worksheetXml->sheetFormatPr)) { $this->sheetFormat($this->worksheetXml->sheetFormatPr); } if (!$readDataOnly && isset($this->worksheetXml->printOptions)) { $this->printOptions($this->worksheetXml->printOptions); } }< private function tabColor(\SimpleXMLElement $sheetPr)> private function tabColor(SimpleXMLElement $sheetPr, Styles $styleReader): void{< if (isset($sheetPr->tabColor, $sheetPr->tabColor['rgb'])) { < $this->worksheet->getTabColor()->setARGB((string) $sheetPr->tabColor['rgb']);> if (isset($sheetPr->tabColor)) { > $this->worksheet->getTabColor()->setARGB($styleReader->readColor($sheetPr->tabColor));} }< private function codeName(\SimpleXMLElement $sheetPr)> private function codeName(SimpleXMLElement $sheetPr): void{ if (isset($sheetPr['codeName'])) { $this->worksheet->setCodeName((string) $sheetPr['codeName'], false); } }< private function outlines(\SimpleXMLElement $sheetPr)> private function outlines(SimpleXMLElement $sheetPr): void{ if (isset($sheetPr->outlinePr)) {< if (isset($sheetPr->outlinePr['summaryRight']) && < !self::boolean((string) $sheetPr->outlinePr['summaryRight'])) {> if ( > isset($sheetPr->outlinePr['summaryRight']) && > !self::boolean((string) $sheetPr->outlinePr['summaryRight']) > ) {$this->worksheet->setShowSummaryRight(false); } else { $this->worksheet->setShowSummaryRight(true); }< if (isset($sheetPr->outlinePr['summaryBelow']) && < !self::boolean((string) $sheetPr->outlinePr['summaryBelow'])) {> if ( > isset($sheetPr->outlinePr['summaryBelow']) && > !self::boolean((string) $sheetPr->outlinePr['summaryBelow']) > ) {$this->worksheet->setShowSummaryBelow(false); } else { $this->worksheet->setShowSummaryBelow(true); } } }< private function pageSetup(\SimpleXMLElement $sheetPr)> private function pageSetup(SimpleXMLElement $sheetPr): void{ if (isset($sheetPr->pageSetUpPr)) {< if (isset($sheetPr->pageSetUpPr['fitToPage']) && < !self::boolean((string) $sheetPr->pageSetUpPr['fitToPage'])) {> if ( > isset($sheetPr->pageSetUpPr['fitToPage']) && > !self::boolean((string) $sheetPr->pageSetUpPr['fitToPage']) > ) {$this->worksheet->getPageSetup()->setFitToPage(false); } else { $this->worksheet->getPageSetup()->setFitToPage(true); } } }< private function sheetFormat(\SimpleXMLElement $sheetFormatPr)> private function sheetFormat(SimpleXMLElement $sheetFormatPr): void{< if (isset($sheetFormatPr['customHeight']) &&> if ( > isset($sheetFormatPr['customHeight']) &&self::boolean((string) $sheetFormatPr['customHeight']) &&< isset($sheetFormatPr['defaultRowHeight'])) {> isset($sheetFormatPr['defaultRowHeight']) > ) {$this->worksheet->getDefaultRowDimension() ->setRowHeight((float) $sheetFormatPr['defaultRowHeight']); } if (isset($sheetFormatPr['defaultColWidth'])) { $this->worksheet->getDefaultColumnDimension() ->setWidth((float) $sheetFormatPr['defaultColWidth']); }< if (isset($sheetFormatPr['zeroHeight']) && < ((string) $sheetFormatPr['zeroHeight'] === '1')) {> if ( > isset($sheetFormatPr['zeroHeight']) && > ((string) $sheetFormatPr['zeroHeight'] === '1') > ) {$this->worksheet->getDefaultRowDimension()->setZeroHeight(true); } }< private function printOptions(\SimpleXMLElement $printOptions)> private function printOptions(SimpleXMLElement $printOptions): void{ if (self::boolean((string) $printOptions['gridLinesSet'])) { $this->worksheet->setShowGridlines(true); } if (self::boolean((string) $printOptions['gridLines'])) { $this->worksheet->setPrintGridlines(true); } if (self::boolean((string) $printOptions['horizontalCentered'])) { $this->worksheet->getPageSetup()->setHorizontalCentered(true); } if (self::boolean((string) $printOptions['verticalCentered'])) { $this->worksheet->getPageSetup()->setVerticalCentered(true); } } }