<?php
namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;
> use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
> use PhpOffice\PhpSpreadsheet\Chart\ChartColor;
use PhpOffice\PhpSpreadsheet\RichText\RichText;
> use PhpOffice\PhpSpreadsheet\Reader\Xlsx\Namespaces;
use PhpOffice\PhpSpreadsheet\RichText\Run;
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
< use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
> use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet as ActualWorksheet;
class StringTable extends WriterPart
{
/**
* Create worksheet stringtable.
*
< * @param Worksheet $pSheet Worksheet
< * @param string[] $pExistingTable Existing table to eventually merge with
> * @param string[] $existingTable Existing table to eventually merge with
*
* @return string[] String table for worksheet
*/
< public function createStringTable(Worksheet $pSheet, $pExistingTable = null)
> public function createStringTable(ActualWorksheet $worksheet, $existingTable = null)
{
// Create string lookup table
$aStringTable = [];
< $cellCollection = null;
< $aFlippedStringTable = null; // For faster lookup
// Is an existing table given?
< if (($pExistingTable !== null) && is_array($pExistingTable)) {
< $aStringTable = $pExistingTable;
> if (($existingTable !== null) && is_array($existingTable)) {
> $aStringTable = $existingTable;
}
// Fill index array
$aFlippedStringTable = $this->flipStringTable($aStringTable);
// Loop through cells
< foreach ($pSheet->getCoordinates() as $coordinate) {
< $cell = $pSheet->getCell($coordinate);
> foreach ($worksheet->getCellCollection()->getCoordinates() as $coordinate) {
> /** @var Cell $cell */
> $cell = $worksheet->getCellCollection()->get($coordinate);
$cellValue = $cell->getValue();
if (
!is_object($cellValue) &&
($cellValue !== null) &&
$cellValue !== '' &&
< !isset($aFlippedStringTable[$cellValue]) &&
< ($cell->getDataType() == DataType::TYPE_STRING || $cell->getDataType() == DataType::TYPE_STRING2 || $cell->getDataType() == DataType::TYPE_NULL)
> ($cell->getDataType() == DataType::TYPE_STRING || $cell->getDataType() == DataType::TYPE_STRING2 || $cell->getDataType() == DataType::TYPE_NULL) &&
> !isset($aFlippedStringTable[$cellValue])
) {
$aStringTable[] = $cellValue;
$aFlippedStringTable[$cellValue] = true;
} elseif (
$cellValue instanceof RichText &&
($cellValue !== null) &&
!isset($aFlippedStringTable[$cellValue->getHashCode()])
) {
$aStringTable[] = $cellValue;
$aFlippedStringTable[$cellValue->getHashCode()] = true;
}
}
return $aStringTable;
}
/**
* Write string table to XML format.
*
< * @param string[] $pStringTable
> * @param (RichText|string)[] $stringTable
*
* @return string XML Output
*/
< public function writeStringTable(array $pStringTable)
> public function writeStringTable(array $stringTable)
{
// Create XML writer
$objWriter = null;
if ($this->getParentWriter()->getUseDiskCaching()) {
$objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
} else {
$objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
}
// XML header
$objWriter->startDocument('1.0', 'UTF-8', 'yes');
// String table
$objWriter->startElement('sst');
< $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
< $objWriter->writeAttribute('uniqueCount', count($pStringTable));
> $objWriter->writeAttribute('xmlns', Namespaces::MAIN);
> $objWriter->writeAttribute('uniqueCount', (string) count($stringTable));
// Loop through string table
< foreach ($pStringTable as $textElement) {
> foreach ($stringTable as $textElement) {
$objWriter->startElement('si');
< if (!$textElement instanceof RichText) {
> if (!($textElement instanceof RichText)) {
$textToWrite = StringHelper::controlCharacterPHP2OOXML($textElement);
$objWriter->startElement('t');
if ($textToWrite !== trim($textToWrite)) {
$objWriter->writeAttribute('xml:space', 'preserve');
}
$objWriter->writeRawData($textToWrite);
$objWriter->endElement();
< } elseif ($textElement instanceof RichText) {
> } else {
$this->writeRichText($objWriter, $textElement);
}
$objWriter->endElement();
}
$objWriter->endElement();
return $objWriter->getData();
}
/**
* Write Rich Text.
*
< * @param XMLWriter $objWriter XML Writer
< * @param RichText $pRichText Rich text
* @param string $prefix Optional Namespace prefix
*/
< public function writeRichText(XMLWriter $objWriter, RichText $pRichText, $prefix = null): void
> public function writeRichText(XMLWriter $objWriter, RichText $richText, $prefix = null): void
{
if ($prefix !== null) {
$prefix .= ':';
}
// Loop through rich text elements
< $elements = $pRichText->getRichTextElements();
> $elements = $richText->getRichTextElements();
foreach ($elements as $element) {
// r
$objWriter->startElement($prefix . 'r');
// rPr
< if ($element instanceof Run) {
> if ($element instanceof Run && $element->getFont() !== null) {
// rPr
$objWriter->startElement($prefix . 'rPr');
// rFont
> if ($element->getFont()->getName() !== null) {
$objWriter->startElement($prefix . 'rFont');
$objWriter->writeAttribute('val', $element->getFont()->getName());
$objWriter->endElement();
> }
// Bold
$objWriter->startElement($prefix . 'b');
$objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
$objWriter->endElement();
// Italic
$objWriter->startElement($prefix . 'i');
$objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
$objWriter->endElement();
// Superscript / subscript
if ($element->getFont()->getSuperscript() || $element->getFont()->getSubscript()) {
$objWriter->startElement($prefix . 'vertAlign');
if ($element->getFont()->getSuperscript()) {
$objWriter->writeAttribute('val', 'superscript');
} elseif ($element->getFont()->getSubscript()) {
$objWriter->writeAttribute('val', 'subscript');
}
$objWriter->endElement();
}
// Strikethrough
$objWriter->startElement($prefix . 'strike');
$objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
$objWriter->endElement();
// Color
> if ($element->getFont()->getColor()->getARGB() !== null) {
$objWriter->startElement($prefix . 'color');
$objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
$objWriter->endElement();
> }
// Size
> if ($element->getFont()->getSize() !== null) {
$objWriter->startElement($prefix . 'sz');
< $objWriter->writeAttribute('val', $element->getFont()->getSize());
> $objWriter->writeAttribute('val', (string) $element->getFont()->getSize());
$objWriter->endElement();
> }
// Underline
> if ($element->getFont()->getUnderline() !== null) {
$objWriter->startElement($prefix . 'u');
$objWriter->writeAttribute('val', $element->getFont()->getUnderline());
$objWriter->endElement();
> }
$objWriter->endElement();
}
// t
$objWriter->startElement($prefix . 't');
$objWriter->writeAttribute('xml:space', 'preserve');
$objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText()));
$objWriter->endElement();
$objWriter->endElement();
}
}
/**
* Write Rich Text.
*
< * @param XMLWriter $objWriter XML Writer
< * @param RichText|string $pRichText text string or Rich text
> * @param RichText|string $richText text string or Rich text
* @param string $prefix Optional Namespace prefix
*/
< public function writeRichTextForCharts(XMLWriter $objWriter, $pRichText = null, $prefix = null): void
> public function writeRichTextForCharts(XMLWriter $objWriter, $richText = null, $prefix = ''): void
{
< if (!$pRichText instanceof RichText) {
< $textRun = $pRichText;
< $pRichText = new RichText();
< $pRichText->createTextRun($textRun);
> if (!($richText instanceof RichText)) {
> $textRun = $richText;
> $richText = new RichText();
> $run = $richText->createTextRun($textRun ?? '');
> $run->setFont(null);
}
< if ($prefix !== null) {
> if ($prefix !== '') {
$prefix .= ':';
}
// Loop through rich text elements
< $elements = $pRichText->getRichTextElements();
> $elements = $richText->getRichTextElements();
foreach ($elements as $element) {
// r
$objWriter->startElement($prefix . 'r');
<
> if ($element->getFont() !== null) {
// rPr
$objWriter->startElement($prefix . 'rPr');
> $fontSize = $element->getFont()->getSize();
> if (is_numeric($fontSize)) {
// Bold
> $fontSize *= (($fontSize < 100) ? 100 : 1);
$objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
> $objWriter->writeAttribute('sz', (string) $fontSize);
// Italic
> }
< $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
> $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? '1' : '0'));
< $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? 1 : 0));
> $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? '1' : '0'));
$underlineType = $element->getFont()->getUnderline();
switch ($underlineType) {
case 'single':
$underlineType = 'sng';
break;
case 'double':
$underlineType = 'dbl';
break;
}
> if ($underlineType !== null) {
$objWriter->writeAttribute('u', $underlineType);
> }
// Strikethrough
< $objWriter->writeAttribute('strike', ($element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike'));
> $objWriter->writeAttribute('strike', ($element->getFont()->getStriketype() ?: 'noStrike'));
> // Superscript/subscript
> if ($element->getFont()->getBaseLine()) {
> $objWriter->writeAttribute('baseline', (string) $element->getFont()->getBaseLine());
> }
< // rFont
> // Color
> $this->writeChartTextColor($objWriter, $element->getFont()->getChartColor(), $prefix);
>
> // Underscore Color
> $this->writeChartTextColor($objWriter, $element->getFont()->getUnderlineColor(), $prefix, 'uFill');
>
> // fontName
> if ($element->getFont()->getLatin()) {
$objWriter->startElement($prefix . 'latin');
< $objWriter->writeAttribute('typeface', $element->getFont()->getName());
> $objWriter->writeAttribute('typeface', $element->getFont()->getLatin());
> $objWriter->endElement();
> }
> if ($element->getFont()->getEastAsian()) {
> $objWriter->startElement($prefix . 'ea');
> $objWriter->writeAttribute('typeface', $element->getFont()->getEastAsian());
$objWriter->endElement();
> }
> if ($element->getFont()->getComplexScript()) {
$objWriter->endElement();
> $objWriter->startElement($prefix . 'cs');
> $objWriter->writeAttribute('typeface', $element->getFont()->getComplexScript());
// t
> $objWriter->endElement();
$objWriter->startElement($prefix . 't');
> }
$objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText()));
> }
$objWriter->endElement();
$objWriter->endElement();
> }
}
> }
}
>
> private function writeChartTextColor(XMLWriter $objWriter, ?ChartColor $underlineColor, string $prefix, ?string $openTag = ''): void
/**
> {
* Flip string table (for index searching).
> if ($underlineColor !== null) {
*
> $type = $underlineColor->getType();
* @param array $stringTable Stringtable
> $value = $underlineColor->getValue();
*
> if (!empty($type) && !empty($value)) {
* @return array
> if ($openTag !== '') {
*/
> $objWriter->startElement($prefix . $openTag);
public function flipStringTable(array $stringTable)
> }
{
> $objWriter->startElement($prefix . 'solidFill');
// Return value
> $objWriter->startElement($prefix . $type);
$returnValue = [];
> $objWriter->writeAttribute('val', $value);
> $alpha = $underlineColor->getAlpha();
// Loop through stringtable and add flipped items to $returnValue
> if (is_numeric($alpha)) {
foreach ($stringTable as $key => $value) {
> $objWriter->startElement('a:alpha');
if (!$value instanceof RichText) {
> $objWriter->writeAttribute('val', ChartColor::alphaToXml((int) $alpha));
$returnValue[$value] = $key;
> $objWriter->endElement();
} elseif ($value instanceof RichText) {
> }
$returnValue[$value->getHashCode()] = $key;
> $objWriter->endElement(); // srgbClr/schemeClr/prstClr
}
> $objWriter->endElement(); // solidFill
}
> if ($openTag !== '') {
> $objWriter->endElement(); // uFill
return $returnValue;
> }
}
> }
}