<?php
|
|
namespace PhpOffice\PhpSpreadsheet\Reader\Gnumeric;
|
|
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
|
use PhpOffice\PhpSpreadsheet\Shared\Date;
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
use PhpOffice\PhpSpreadsheet\Style\Alignment;
|
use PhpOffice\PhpSpreadsheet\Style\Border;
|
use PhpOffice\PhpSpreadsheet\Style\Borders;
|
use PhpOffice\PhpSpreadsheet\Style\Fill;
|
use PhpOffice\PhpSpreadsheet\Style\Font;
|
use SimpleXMLElement;
|
|
class Styles
|
{
|
private Spreadsheet $spreadsheet;
|
|
protected bool $readDataOnly;
|
|
public static array $mappings = [
|
'borderStyle' => [
|
'0' => Border::BORDER_NONE,
|
'1' => Border::BORDER_THIN,
|
'2' => Border::BORDER_MEDIUM,
|
'3' => Border::BORDER_SLANTDASHDOT,
|
'4' => Border::BORDER_DASHED,
|
'5' => Border::BORDER_THICK,
|
'6' => Border::BORDER_DOUBLE,
|
'7' => Border::BORDER_DOTTED,
|
'8' => Border::BORDER_MEDIUMDASHED,
|
'9' => Border::BORDER_DASHDOT,
|
'10' => Border::BORDER_MEDIUMDASHDOT,
|
'11' => Border::BORDER_DASHDOTDOT,
|
'12' => Border::BORDER_MEDIUMDASHDOTDOT,
|
'13' => Border::BORDER_MEDIUMDASHDOTDOT,
|
],
|
'fillType' => [
|
'1' => Fill::FILL_SOLID,
|
'2' => Fill::FILL_PATTERN_DARKGRAY,
|
'3' => Fill::FILL_PATTERN_MEDIUMGRAY,
|
'4' => Fill::FILL_PATTERN_LIGHTGRAY,
|
'5' => Fill::FILL_PATTERN_GRAY125,
|
'6' => Fill::FILL_PATTERN_GRAY0625,
|
'7' => Fill::FILL_PATTERN_DARKHORIZONTAL, // horizontal stripe
|
'8' => Fill::FILL_PATTERN_DARKVERTICAL, // vertical stripe
|
'9' => Fill::FILL_PATTERN_DARKDOWN, // diagonal stripe
|
'10' => Fill::FILL_PATTERN_DARKUP, // reverse diagonal stripe
|
'11' => Fill::FILL_PATTERN_DARKGRID, // diagoanl crosshatch
|
'12' => Fill::FILL_PATTERN_DARKTRELLIS, // thick diagonal crosshatch
|
'13' => Fill::FILL_PATTERN_LIGHTHORIZONTAL,
|
'14' => Fill::FILL_PATTERN_LIGHTVERTICAL,
|
'15' => Fill::FILL_PATTERN_LIGHTUP,
|
'16' => Fill::FILL_PATTERN_LIGHTDOWN,
|
'17' => Fill::FILL_PATTERN_LIGHTGRID, // thin horizontal crosshatch
|
'18' => Fill::FILL_PATTERN_LIGHTTRELLIS, // thin diagonal crosshatch
|
],
|
'horizontal' => [
|
'1' => Alignment::HORIZONTAL_GENERAL,
|
'2' => Alignment::HORIZONTAL_LEFT,
|
'4' => Alignment::HORIZONTAL_RIGHT,
|
'8' => Alignment::HORIZONTAL_CENTER,
|
'16' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
|
'32' => Alignment::HORIZONTAL_JUSTIFY,
|
'64' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
|
],
|
'underline' => [
|
'1' => Font::UNDERLINE_SINGLE,
|
'2' => Font::UNDERLINE_DOUBLE,
|
'3' => Font::UNDERLINE_SINGLEACCOUNTING,
|
'4' => Font::UNDERLINE_DOUBLEACCOUNTING,
|
],
|
'vertical' => [
|
'1' => Alignment::VERTICAL_TOP,
|
'2' => Alignment::VERTICAL_BOTTOM,
|
'4' => Alignment::VERTICAL_CENTER,
|
'8' => Alignment::VERTICAL_JUSTIFY,
|
],
|
];
|
|
public function __construct(Spreadsheet $spreadsheet, bool $readDataOnly)
|
{
|
$this->spreadsheet = $spreadsheet;
|
$this->readDataOnly = $readDataOnly;
|
}
|
|
public function read(SimpleXMLElement $sheet, int $maxRow, int $maxCol): void
|
{
|
if ($sheet->Styles->StyleRegion !== null) {
|
$this->readStyles($sheet->Styles->StyleRegion, $maxRow, $maxCol);
|
}
|
}
|
|
private function readStyles(SimpleXMLElement $styleRegion, int $maxRow, int $maxCol): void
|
{
|
foreach ($styleRegion as $style) {
|
$styleAttributes = $style->attributes();
|
if ($styleAttributes !== null && ($styleAttributes['startRow'] <= $maxRow) && ($styleAttributes['startCol'] <= $maxCol)) {
|
$cellRange = $this->readStyleRange($styleAttributes, $maxCol, $maxRow);
|
|
$styleAttributes = $style->Style->attributes();
|
|
$styleArray = [];
|
// We still set the number format mask for date/time values, even if readDataOnly is true
|
// so that we can identify whether a float is a float or a date value
|
$formatCode = $styleAttributes ? (string) $styleAttributes['Format'] : null;
|
if ($formatCode && Date::isDateTimeFormatCode($formatCode)) {
|
$styleArray['numberFormat']['formatCode'] = $formatCode;
|
}
|
if ($this->readDataOnly === false && $styleAttributes !== null) {
|
// If readDataOnly is false, we set all formatting information
|
$styleArray['numberFormat']['formatCode'] = $formatCode;
|
$styleArray = $this->readStyle($styleArray, $styleAttributes, $style);
|
}
|
$this->spreadsheet->getActiveSheet()->getStyle($cellRange)->applyFromArray($styleArray);
|
}
|
}
|
}
|
|
private function addBorderDiagonal(SimpleXMLElement $srssb, array &$styleArray): void
|
{
|
if (isset($srssb->Diagonal, $srssb->{'Rev-Diagonal'})) {
|
$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
|
$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_BOTH;
|
} elseif (isset($srssb->Diagonal)) {
|
$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
|
$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_UP;
|
} elseif (isset($srssb->{'Rev-Diagonal'})) {
|
$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->{'Rev-Diagonal'}->attributes());
|
$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_DOWN;
|
}
|
}
|
|
private function addBorderStyle(SimpleXMLElement $srssb, array &$styleArray, string $direction): void
|
{
|
$ucDirection = ucfirst($direction);
|
if (isset($srssb->$ucDirection)) {
|
$styleArray['borders'][$direction] = self::parseBorderAttributes($srssb->$ucDirection->attributes());
|
}
|
}
|
|
private function calcRotation(SimpleXMLElement $styleAttributes): int
|
{
|
$rotation = (int) $styleAttributes->Rotation;
|
if ($rotation >= 270 && $rotation <= 360) {
|
$rotation -= 360;
|
}
|
$rotation = (abs($rotation) > 90) ? 0 : $rotation;
|
|
return $rotation;
|
}
|
|
private static function addStyle(array &$styleArray, string $key, string $value): void
|
{
|
if (array_key_exists($value, self::$mappings[$key])) {
|
$styleArray[$key] = self::$mappings[$key][$value];
|
}
|
}
|
|
private static function addStyle2(array &$styleArray, string $key1, string $key, string $value): void
|
{
|
if (array_key_exists($value, self::$mappings[$key])) {
|
$styleArray[$key1][$key] = self::$mappings[$key][$value];
|
}
|
}
|
|
private static function parseBorderAttributes(?SimpleXMLElement $borderAttributes): array
|
{
|
$styleArray = [];
|
if ($borderAttributes !== null) {
|
if (isset($borderAttributes['Color'])) {
|
$styleArray['color']['rgb'] = self::parseGnumericColour($borderAttributes['Color']);
|
}
|
|
self::addStyle($styleArray, 'borderStyle', (string) $borderAttributes['Style']);
|
}
|
|
return $styleArray;
|
}
|
|
private static function parseGnumericColour(string $gnmColour): string
|
{
|
[$gnmR, $gnmG, $gnmB] = explode(':', $gnmColour);
|
$gnmR = substr(str_pad($gnmR, 4, '0', STR_PAD_RIGHT), 0, 2);
|
$gnmG = substr(str_pad($gnmG, 4, '0', STR_PAD_RIGHT), 0, 2);
|
$gnmB = substr(str_pad($gnmB, 4, '0', STR_PAD_RIGHT), 0, 2);
|
|
return $gnmR . $gnmG . $gnmB;
|
}
|
|
private function addColors(array &$styleArray, SimpleXMLElement $styleAttributes): void
|
{
|
$RGB = self::parseGnumericColour((string) $styleAttributes['Fore']);
|
$styleArray['font']['color']['rgb'] = $RGB;
|
$RGB = self::parseGnumericColour((string) $styleAttributes['Back']);
|
$shade = (string) $styleAttributes['Shade'];
|
if (($RGB !== '000000') || ($shade !== '0')) {
|
$RGB2 = self::parseGnumericColour((string) $styleAttributes['PatternColor']);
|
if ($shade === '1') {
|
$styleArray['fill']['startColor']['rgb'] = $RGB;
|
$styleArray['fill']['endColor']['rgb'] = $RGB2;
|
} else {
|
$styleArray['fill']['endColor']['rgb'] = $RGB;
|
$styleArray['fill']['startColor']['rgb'] = $RGB2;
|
}
|
self::addStyle2($styleArray, 'fill', 'fillType', $shade);
|
}
|
}
|
|
private function readStyleRange(SimpleXMLElement $styleAttributes, int $maxCol, int $maxRow): string
|
{
|
$startColumn = Coordinate::stringFromColumnIndex((int) $styleAttributes['startCol'] + 1);
|
$startRow = $styleAttributes['startRow'] + 1;
|
|
$endColumn = ($styleAttributes['endCol'] > $maxCol) ? $maxCol : (int) $styleAttributes['endCol'];
|
$endColumn = Coordinate::stringFromColumnIndex($endColumn + 1);
|
|
$endRow = 1 + (($styleAttributes['endRow'] > $maxRow) ? $maxRow : (int) $styleAttributes['endRow']);
|
$cellRange = $startColumn . $startRow . ':' . $endColumn . $endRow;
|
|
return $cellRange;
|
}
|
|
private function readStyle(array $styleArray, SimpleXMLElement $styleAttributes, SimpleXMLElement $style): array
|
{
|
self::addStyle2($styleArray, 'alignment', 'horizontal', (string) $styleAttributes['HAlign']);
|
self::addStyle2($styleArray, 'alignment', 'vertical', (string) $styleAttributes['VAlign']);
|
$styleArray['alignment']['wrapText'] = $styleAttributes['WrapText'] == '1';
|
$styleArray['alignment']['textRotation'] = $this->calcRotation($styleAttributes);
|
$styleArray['alignment']['shrinkToFit'] = $styleAttributes['ShrinkToFit'] == '1';
|
$styleArray['alignment']['indent'] = ((int) ($styleAttributes['Indent']) > 0) ? $styleAttributes['indent'] : 0;
|
|
$this->addColors($styleArray, $styleAttributes);
|
|
$fontAttributes = $style->Style->Font->attributes();
|
if ($fontAttributes !== null) {
|
$styleArray['font']['name'] = (string) $style->Style->Font;
|
$styleArray['font']['size'] = (int) ($fontAttributes['Unit']);
|
$styleArray['font']['bold'] = $fontAttributes['Bold'] == '1';
|
$styleArray['font']['italic'] = $fontAttributes['Italic'] == '1';
|
$styleArray['font']['strikethrough'] = $fontAttributes['StrikeThrough'] == '1';
|
self::addStyle2($styleArray, 'font', 'underline', (string) $fontAttributes['Underline']);
|
|
switch ($fontAttributes['Script']) {
|
case '1':
|
$styleArray['font']['superscript'] = true;
|
|
break;
|
case '-1':
|
$styleArray['font']['subscript'] = true;
|
|
break;
|
}
|
}
|
|
if (isset($style->Style->StyleBorder)) {
|
$srssb = $style->Style->StyleBorder;
|
$this->addBorderStyle($srssb, $styleArray, 'top');
|
$this->addBorderStyle($srssb, $styleArray, 'bottom');
|
$this->addBorderStyle($srssb, $styleArray, 'left');
|
$this->addBorderStyle($srssb, $styleArray, 'right');
|
$this->addBorderDiagonal($srssb, $styleArray);
|
}
|
// TO DO
|
/*
|
if (isset($style->Style->HyperLink)) {
|
$hyperlink = $style->Style->HyperLink->attributes();
|
}
|
*/
|
|
return $styleArray;
|
}
|
}
|
