<?php
|
|
namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx;
|
|
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
|
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
|
use PhpOffice\PhpSpreadsheet\Worksheet\Pane;
|
use 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);
|
}
|
}
|
}
|
}
|
}
|
