# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/SheetViews.php

TablePress – Tables in WordPress made easy, version 3.4. 200 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/SheetViews.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/SheetViews.php
- Modified: 2025-01-08T09:25:54+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/SheetViews.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx;

use TablePress\PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Pane;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use SimpleXMLElement;

class SheetViews extends BaseParserClass
{
	private SimpleXMLElement $sheetViewXml;

	private SimpleXMLElement $sheetViewAttributes;

	private Worksheet $worksheet;

	private string $activePane = '';

	public function __construct(SimpleXMLElement $sheetViewXml, Worksheet $workSheet)
	{
		$this->sheetViewXml = $sheetViewXml;
		$this->sheetViewAttributes = Xlsx::testSimpleXml($sheetViewXml->attributes());
		$this->worksheet = $workSheet;
	}

	public function load(): void
	{
		$this->topLeft();
		$this->zoomScale();
		$this->view();
		$this->gridLines();
		$this->headers();
		$this->direction();
		$this->showZeros();

		$usesPanes = false;
		if (isset($this->sheetViewXml->pane)) {
			$this->pane();
			$usesPanes = true;
		}
		if (isset($this->sheetViewXml->selection)) {
			foreach ($this->sheetViewXml->selection as $selection) {
				$this->selection($selection, $usesPanes);
			}
		}
	}

	private function zoomScale(): void
	{
		if (isset($this->sheetViewAttributes->zoomScale)) {
			$zoomScale = (int) ($this->sheetViewAttributes->zoomScale);
			if ($zoomScale <= 0) {
				// setZoomScale will throw an Exception if the scale is less than or equals 0
				// that is OK when manually creating documents, but we should be able to read all documents
				$zoomScale = 100;
			}

			$this->worksheet->getSheetView()->setZoomScale($zoomScale);
		}

		if (isset($this->sheetViewAttributes->zoomScaleNormal)) {
			$zoomScaleNormal = (int) ($this->sheetViewAttributes->zoomScaleNormal);
			if ($zoomScaleNormal <= 0) {
				// setZoomScaleNormal will throw an Exception if the scale is less than or equals 0
				// that is OK when manually creating documents, but we should be able to read all documents
				$zoomScaleNormal = 100;
			}

			$this->worksheet->getSheetView()->setZoomScaleNormal($zoomScaleNormal);
		}

		if (isset($this->sheetViewAttributes->zoomScalePageLayoutView)) {
			$zoomScaleNormal = (int) ($this->sheetViewAttributes->zoomScalePageLayoutView);
			if ($zoomScaleNormal > 0) {
				$this->worksheet->getSheetView()->setZoomScalePageLayoutView($zoomScaleNormal);
			}
		}

		if (isset($this->sheetViewAttributes->zoomScaleSheetLayoutView)) {
			$zoomScaleNormal = (int) ($this->sheetViewAttributes->zoomScaleSheetLayoutView);
			if ($zoomScaleNormal > 0) {
				$this->worksheet->getSheetView()->setZoomScaleSheetLayoutView($zoomScaleNormal);
			}
		}
	}

	private function view(): void
	{
		if (isset($this->sheetViewAttributes->view)) {
			$this->worksheet->getSheetView()->setView((string) $this->sheetViewAttributes->view);
		}
	}

	private function topLeft(): void
	{
		if (isset($this->sheetViewAttributes->topLeftCell)) {
			$this->worksheet->setTopLeftCell($this->sheetViewAttributes->topLeftCell);
		}
	}

	private function gridLines(): void
	{
		if (isset($this->sheetViewAttributes->showGridLines)) {
			$this->worksheet->setShowGridLines(
				self::boolean((string) $this->sheetViewAttributes->showGridLines)
			);
		}
	}

	private function headers(): void
	{
		if (isset($this->sheetViewAttributes->showRowColHeaders)) {
			$this->worksheet->setShowRowColHeaders(
				self::boolean((string) $this->sheetViewAttributes->showRowColHeaders)
			);
		}
	}

	private function direction(): void
	{
		if (isset($this->sheetViewAttributes->rightToLeft)) {
			$this->worksheet->setRightToLeft(
				self::boolean((string) $this->sheetViewAttributes->rightToLeft)
			);
		}
	}

	private function showZeros(): void
	{
		if (isset($this->sheetViewAttributes->showZeros)) {
			$this->worksheet->getSheetView()->setShowZeros(
				self::boolean((string) $this->sheetViewAttributes->showZeros)
			);
		}
	}

	private function pane(): void
	{
		$xSplit = 0;
		$ySplit = 0;
		$topLeftCell = null;
		$paneAttributes = $this->sheetViewXml->pane->attributes();

		if (isset($paneAttributes->xSplit)) {
			$xSplit = (int) ($paneAttributes->xSplit);
			$this->worksheet->setXSplit($xSplit);
		}

		if (isset($paneAttributes->ySplit)) {
			$ySplit = (int) ($paneAttributes->ySplit);
			$this->worksheet->setYSplit($ySplit);
		}
		$paneState = isset($paneAttributes->state) ? ((string) $paneAttributes->state) : '';
		$this->worksheet->setPaneState($paneState);
		if (isset($paneAttributes->topLeftCell)) {
			$topLeftCell = (string) $paneAttributes->topLeftCell;
			$this->worksheet->setPaneTopLeftCell($topLeftCell);
			if ($paneState === Worksheet::PANE_FROZEN) {
				$this->worksheet->setTopLeftCell($topLeftCell);
			}
		}
		$activePane = isset($paneAttributes->activePane) ? ((string) $paneAttributes->activePane) : 'topLeft';
		$this->worksheet->setActivePane($activePane);
		$this->activePane = $activePane;
		if ($paneState === Worksheet::PANE_FROZEN || $paneState === Worksheet::PANE_FROZENSPLIT) {
			$this->worksheet->freezePane(
				Coordinate::stringFromColumnIndex($xSplit + 1) . ($ySplit + 1),
				$topLeftCell,
				$paneState === Worksheet::PANE_FROZENSPLIT
			);
		}
	}

	private function selection(?SimpleXMLElement $selection, bool $usesPanes): void
	{
		$attributes = ($selection === null) ? null : $selection->attributes();
		if ($attributes !== null) {
			$position = (string) $attributes->pane;
			if ($usesPanes && $position === '') {
				$position = 'topLeft';
			}
			$activeCell = (string) $attributes->activeCell;
			$sqref = (string) $attributes->sqref;
			$sqref = explode(' ', $sqref);
			$sqref = $sqref[0];
			if ($position === '') {
				$this->worksheet->setSelectedCells($sqref);
			} else {
				$pane = new Pane($position, $sqref, $activeCell);
				$this->worksheet->setPane($position, $pane);
				if ($position === $this->activePane && $sqref !== '') {
					$this->worksheet->setSelectedCells($sqref);
				}
			}
		}
	}
}

```