# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Reader/Xml/Style.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Reader/Xml/Style.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Reader/Xml/Style.php
- Modified: 2025-10-28T04:41:40+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/Xml/Style.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Xml;

use TablePress\PhpOffice\PhpSpreadsheet\Style\Protection;
use SimpleXMLElement;

class Style
{
	/**
	 * Formats.
	 *
	 * @var mixed[]
	 */
	protected array $styles = [];

	/**
	 * @param string[] $namespaces
	 *
	 * @return mixed[]
	 */
	public function parseStyles(SimpleXMLElement $xml, array $namespaces): array
	{
		$children = $xml->children('urn:schemas-microsoft-com:office:spreadsheet');
		$stylesXml = $children->Styles[0];
		if (!isset($stylesXml)) {
			return [];
		}

		$alignmentStyleParser = new Style\Alignment();
		$borderStyleParser = new Style\Border();
		$fontStyleParser = new Style\Font();
		$fillStyleParser = new Style\Fill();
		$numberFormatStyleParser = new Style\NumberFormat();

		foreach ($stylesXml as $style) {
			/** @var SimpleXMLElement $style */
			$style_ss = self::getAttributes($style, $namespaces['ss']);
			$styleID = (string) $style_ss['ID'];
			$this->styles[$styleID] = $this->styles['Default'] ?? [];

			$alignment = $border = $font = $fill = $numberFormat = $protection = [];

			foreach ($style as $styleType => $styleDatax) {
				$styleData = self::getSxml($styleDatax);
				$styleAttributes = $styleData->attributes($namespaces['ss']);

				switch ($styleType) {
					case 'Alignment':
						if ($styleAttributes) {
							$alignment = $alignmentStyleParser->parseStyle($styleAttributes);
						}

						break;
					case 'Borders':
						$border = $borderStyleParser->parseStyle($styleData, $namespaces);

						break;
					case 'Font':
						if ($styleAttributes) {
							$font = $fontStyleParser->parseStyle($styleAttributes);
						}

						break;
					case 'Interior':
						if ($styleAttributes) {
							$fill = $fillStyleParser->parseStyle($styleAttributes);
						}

						break;
					case 'NumberFormat':
						if ($styleAttributes) {
							$numberFormat = $numberFormatStyleParser->parseStyle($styleAttributes);
						}

						break;
					case 'Protection':
						$locked = $hidden = null;
						$styleAttributesP = array_key_exists('x', $namespaces) ? $styleData->attributes($namespaces['x']) : [];
						if (isset($styleAttributes['Protected'])) {
							$locked = ((bool) (string) $styleAttributes['Protected']) ? Protection::PROTECTION_PROTECTED : Protection::PROTECTION_UNPROTECTED;
						}
						if (isset($styleAttributesP['HideFormula'])) {
							$hidden = ((bool) (string) $styleAttributesP['HideFormula']) ? Protection::PROTECTION_PROTECTED : Protection::PROTECTION_UNPROTECTED;
						}
						if ($locked !== null || $hidden !== null) {
							$protection['protection'] = [];
							if ($locked !== null) {
								$protection['protection']['locked'] = $locked;
							}
							if ($hidden !== null) {
								$protection['protection']['hidden'] = $hidden;
							}
						}

						break;
				}
			}

			$this->styles[$styleID] = array_merge($alignment, $border, $font, $fill, $numberFormat, $protection);
		}

		return $this->styles;
	}

	private static function getAttributes(?SimpleXMLElement $simple, string $node): SimpleXMLElement
	{
		return ($simple === null) ? new SimpleXMLElement('<xml></xml>') : ($simple->attributes($node) ?? new SimpleXMLElement('<xml></xml>'));
	}

	private static function getSxml(?SimpleXMLElement $simple): SimpleXMLElement
	{
		return ($simple !== null) ? $simple : new SimpleXMLElement('<xml></xml>');
	}
}

```