Content::writeRows() - Code Metrics - Inspection of "Merge pull request #4369 from oleibman/stanbleed03" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 2661ad...b3452a )

unknown

created 2025-02-22 00:03 UTC

Content::writeRows() B

↳ Parent: Content

Complexity

Conditions	7
Paths	11

Size

Total Lines	29
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	25
CRAP Score	7

Importance

Changes

Metric	Value
eloc	23
dl	0
loc	29
ccs	25
cts	25
cp	1
rs	8.6186
c	0
b	0
f	0
cc	7
nc	11
nop	3
crap	7

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Ods;

use Composer\Pcre\Preg;
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use PhpOffice\PhpSpreadsheet\Calculation\Exception as CalculationException;
use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Worksheet\RowCellIterator;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Writer\Ods;
use PhpOffice\PhpSpreadsheet\Writer\Ods\Cell\Comment;
use PhpOffice\PhpSpreadsheet\Writer\Ods\Cell\Style;

/**
 * @author     Alexander Pervakov <[email protected]>
 */
class Content extends WriterPart
{
    private Formula $formulaConvertor;

    /**
     * Set parent Ods writer.
     */
    public function __construct(Ods $writer)
    {
        parent::__construct($writer);

        $this->formulaConvertor = new Formula($this->getParentWriter()->getSpreadsheet()->getDefinedNames());
    }

    /**
     * Write content.xml to XML format.
     *
     * @return string XML Output
     */
    public function write(): string
    {
        $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');

        // Content
        $objWriter->startElement('office:document-content');
        $objWriter->writeAttribute('xmlns:office', 'urn:oasis:names:tc:opendocument:xmlns:office:1.0');
        $objWriter->writeAttribute('xmlns:style', 'urn:oasis:names:tc:opendocument:xmlns:style:1.0');
        $objWriter->writeAttribute('xmlns:text', 'urn:oasis:names:tc:opendocument:xmlns:text:1.0');
        $objWriter->writeAttribute('xmlns:table', 'urn:oasis:names:tc:opendocument:xmlns:table:1.0');
        $objWriter->writeAttribute('xmlns:draw', 'urn:oasis:names:tc:opendocument:xmlns:drawing:1.0');
        $objWriter->writeAttribute('xmlns:fo', 'urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0');
        $objWriter->writeAttribute('xmlns:xlink', 'http://www.w3.org/1999/xlink');
        $objWriter->writeAttribute('xmlns:dc', 'http://purl.org/dc/elements/1.1/');
        $objWriter->writeAttribute('xmlns:meta', 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0');
        $objWriter->writeAttribute('xmlns:number', 'urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0');
        $objWriter->writeAttribute('xmlns:presentation', 'urn:oasis:names:tc:opendocument:xmlns:presentation:1.0');
        $objWriter->writeAttribute('xmlns:svg', 'urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0');
        $objWriter->writeAttribute('xmlns:chart', 'urn:oasis:names:tc:opendocument:xmlns:chart:1.0');
        $objWriter->writeAttribute('xmlns:dr3d', 'urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0');
        $objWriter->writeAttribute('xmlns:math', 'http://www.w3.org/1998/Math/MathML');
        $objWriter->writeAttribute('xmlns:form', 'urn:oasis:names:tc:opendocument:xmlns:form:1.0');
        $objWriter->writeAttribute('xmlns:script', 'urn:oasis:names:tc:opendocument:xmlns:script:1.0');
        $objWriter->writeAttribute('xmlns:ooo', 'http://openoffice.org/2004/office');
        $objWriter->writeAttribute('xmlns:ooow', 'http://openoffice.org/2004/writer');
        $objWriter->writeAttribute('xmlns:oooc', 'http://openoffice.org/2004/calc');
        $objWriter->writeAttribute('xmlns:dom', 'http://www.w3.org/2001/xml-events');
        $objWriter->writeAttribute('xmlns:xforms', 'http://www.w3.org/2002/xforms');
        $objWriter->writeAttribute('xmlns:xsd', 'http://www.w3.org/2001/XMLSchema');
        $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
        $objWriter->writeAttribute('xmlns:rpt', 'http://openoffice.org/2005/report');
        $objWriter->writeAttribute('xmlns:of', 'urn:oasis:names:tc:opendocument:xmlns:of:1.2');
        $objWriter->writeAttribute('xmlns:xhtml', 'http://www.w3.org/1999/xhtml');
        $objWriter->writeAttribute('xmlns:grddl', 'http://www.w3.org/2003/g/data-view#');
        $objWriter->writeAttribute('xmlns:tableooo', 'http://openoffice.org/2009/table');
        $objWriter->writeAttribute('xmlns:field', 'urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0');
        $objWriter->writeAttribute('xmlns:formx', 'urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0');
        $objWriter->writeAttribute('xmlns:css3t', 'http://www.w3.org/TR/css3-text/');
        $objWriter->writeAttribute('office:version', '1.2');

        $objWriter->writeElement('office:scripts');
        $objWriter->writeElement('office:font-face-decls');

        // Styles XF
        $objWriter->startElement('office:automatic-styles');
        $this->writeXfStyles($objWriter, $this->getParentWriter()->getSpreadsheet());
        $objWriter->endElement();

        $objWriter->startElement('office:body');
        $objWriter->startElement('office:spreadsheet');
        $objWriter->writeElement('table:calculation-settings');

        $this->writeSheets($objWriter);

        (new AutoFilters($objWriter, $this->getParentWriter()->getSpreadsheet()))->write();
        // Defined names (ranges and formulae)
        (new NamedExpressions($objWriter, $this->getParentWriter()->getSpreadsheet(), $this->formulaConvertor))->write();

        $objWriter->endElement();
        $objWriter->endElement();
        $objWriter->endElement();

        return $objWriter->getData();
    }

    /**
     * Write sheets.
     */
    private function writeSheets(XMLWriter $objWriter): void
    {
        $spreadsheet = $this->getParentWriter()->getSpreadsheet();
        $sheetCount = $spreadsheet->getSheetCount();
        for ($sheetIndex = 0; $sheetIndex < $sheetCount; ++$sheetIndex) {
            $spreadsheet->getSheet($sheetIndex)->calculateArrays($this->getParentWriter()->getPreCalculateFormulas());
            $objWriter->startElement('table:table');
            $objWriter->writeAttribute('table:name', $spreadsheet->getSheet($sheetIndex)->getTitle());
            $objWriter->writeAttribute('table:style-name', Style::TABLE_STYLE_PREFIX . (string) ($sheetIndex + 1));
            $objWriter->writeElement('office:forms');
            $lastColumn = 0;
            foreach ($spreadsheet->getSheet($sheetIndex)->getColumnDimensions() as $columnDimension) {
                $thisColumn = $columnDimension->getColumnNumeric();
                $emptyColumns = $thisColumn - $lastColumn - 1;
                if ($emptyColumns > 0) {
                    $objWriter->startElement('table:table-column');
                    $objWriter->writeAttribute('table:number-columns-repeated', (string) $emptyColumns);
                    $objWriter->endElement();
                }
                $lastColumn = $thisColumn;
                $objWriter->startElement('table:table-column');
                $objWriter->writeAttribute(
                    'table:style-name',
                    sprintf('%s_%d_%d', Style::COLUMN_STYLE_PREFIX, $sheetIndex, $columnDimension->getColumnNumeric())
                );
                $objWriter->writeAttribute('table:default-cell-style-name', 'ce0');
                $objWriter->endElement();
            }
            $this->writeRows($objWriter, $spreadsheet->getSheet($sheetIndex), $sheetIndex);
            $objWriter->endElement();
        }
    }

    /**
     * Write rows of the specified sheet.
     */
    private function writeRows(XMLWriter $objWriter, Worksheet $sheet, int $sheetIndex): void
    {
        $spanRow = 0;
        $rows = $sheet->getRowIterator();
        foreach ($rows as $row) {
            $cellIterator = $row->getCellIterator(iterateOnlyExistingCells: true);
            $cellIterator->rewind();
            $rowStyleExists = $sheet->rowDimensionExists($row->getRowIndex()) && $sheet->getRowDimension($row->getRowIndex())->getRowHeight() > 0;
            if ($cellIterator->valid() || $rowStyleExists) {
                if ($spanRow) {
                    $objWriter->startElement('table:table-row');
                    $objWriter->writeAttribute(
                        'table:number-rows-repeated',
                        (string) $spanRow
                    );
                    $objWriter->endElement();
                    $spanRow = 0;
                }
                $objWriter->startElement('table:table-row');
                if ($rowStyleExists) {
                    $objWriter->writeAttribute(
                        'table:style-name',
                        sprintf('%s_%d_%d', Style::ROW_STYLE_PREFIX, $sheetIndex, $row->getRowIndex())
                    );
                }
                $this->writeCells($objWriter, $cellIterator);
                $objWriter->endElement();
            } else {
                ++$spanRow;
            }
        }
    }

    /**
     * Write cells of the specified row.
     */
    private function writeCells(XMLWriter $objWriter, RowCellIterator $cells): void
    {
        $prevColumn = -1;
        foreach ($cells as $cell) {
            /** @var Cell $cell */
            $column = Coordinate::columnIndexFromString($cell->getColumn()) - 1;
            $attributes = $cell->getFormulaAttributes() ?? [];

            $this->writeCellSpan($objWriter, $column, $prevColumn);
            $objWriter->startElement('table:table-cell');
            $this->writeCellMerge($objWriter, $cell);

            // Style XF
            $style = $cell->getXfIndex();
            $objWriter->writeAttribute('table:style-name', Style::CELL_STYLE_PREFIX . $style);

            switch ($cell->getDataType()) {
                case DataType::TYPE_BOOL:
                    $objWriter->writeAttribute('office:value-type', 'boolean');
                    $objWriter->writeAttribute('office:boolean-value', $cell->getValue() ? 'true' : 'false');
                    $objWriter->writeElement('text:p', Calculation::getInstance()->getLocaleBoolean($cell->getValue() ? 'TRUE' : 'FALSE'));

                    break;
                case DataType::TYPE_ERROR:
                    $objWriter->writeAttribute('table:formula', 'of:=#NULL!');
                    $objWriter->writeAttribute('office:value-type', 'string');
                    $objWriter->writeAttribute('office:string-value', '');
                    $objWriter->writeElement('text:p', '#NULL!');

                    break;
                case DataType::TYPE_FORMULA:
                    $formulaValue = $cell->getValueString();
                    if ($this->getParentWriter()->getPreCalculateFormulas()) {
                        try {
                            $formulaValue = $cell->getCalculatedValueString();
                        } catch (CalculationException $e) {
                            // don't do anything
                        }
                    }
                    if (isset($attributes['ref'])) {
                        if (Preg::isMatch('/^([A-Z]{1,3})([0-9]{1,7})(:([A-Z]{1,3})([0-9]{1,7}))?$/', (string) $attributes['ref'], $matches)) {
                            $matrixRowSpan = 1;
                            $matrixColSpan = 1;
                            if (isset($matches[3])) {
                                $minRow = (int) $matches[2];
                                $maxRow = (int) $matches[5];
                                $matrixRowSpan = $maxRow - $minRow + 1;
                                $minCol = Coordinate::columnIndexFromString($matches[1]);
                                $maxCol = Coordinate::columnIndexFromString($matches[4]);
                                $matrixColSpan = $maxCol - $minCol + 1;
                            }
                            $objWriter->writeAttribute('table:number-matrix-columns-spanned', "$matrixColSpan");
                            $objWriter->writeAttribute('table:number-matrix-rows-spanned', "$matrixRowSpan");
                        }
                    }
                    $objWriter->writeAttribute('table:formula', $this->formulaConvertor->convertFormula($cell->getValueString()));
                    if (is_numeric($formulaValue)) {
                        $objWriter->writeAttribute('office:value-type', 'float');
                    } else {
                        $objWriter->writeAttribute('office:value-type', 'string');
                    }
                    $objWriter->writeAttribute('office:value', $formulaValue);
                    $objWriter->writeElement('text:p', $formulaValue);

                    break;
                case DataType::TYPE_NUMERIC:
                    $objWriter->writeAttribute('office:value-type', 'float');
                    $objWriter->writeAttribute('office:value', $cell->getValueString());
                    $objWriter->writeElement('text:p', $cell->getValueString());

                    break;
                case DataType::TYPE_INLINE:
                    // break intentionally omitted
                case DataType::TYPE_STRING:
                    $objWriter->writeAttribute('office:value-type', 'string');
                    $url = $cell->getHyperlink()->getUrl();
                    if (empty($url)) {
                        $objWriter->writeElement('text:p', $cell->getValueString());
                    } else {
                        $objWriter->startElement('text:p');
                        $objWriter->startElement('text:a');
                        $sheets = 'sheet://';
                        $lensheets = strlen($sheets);
                        if (substr($url, 0, $lensheets) === $sheets) {
                            $url = '#' . substr($url, $lensheets);
                        }
                        $objWriter->writeAttribute('xlink:href', $url);
                        $objWriter->writeAttribute('xlink:type', 'simple');
                        $objWriter->text($cell->getValueString());
                        $objWriter->endElement(); // text:a
                        $objWriter->endElement(); // text:p
                    }

                    break;
            }
            Comment::write($objWriter, $cell);
            $objWriter->endElement();
            $prevColumn = $column;
        }
    }

    /**
     * Write span.
     */
    private function writeCellSpan(XMLWriter $objWriter, int $curColumn, int $prevColumn): void
    {
        $diff = $curColumn - $prevColumn - 1;
        if (1 === $diff) {
            $objWriter->writeElement('table:table-cell');
        } elseif ($diff > 1) {
            $objWriter->startElement('table:table-cell');
            $objWriter->writeAttribute('table:number-columns-repeated', (string) $diff);
            $objWriter->endElement();
        }
    }

    /**
     * Write XF cell styles.
     */
    private function writeXfStyles(XMLWriter $writer, Spreadsheet $spreadsheet): void
    {
        $styleWriter = new Style($writer);

        $sheetCount = $spreadsheet->getSheetCount();
        for ($i = 0; $i < $sheetCount; ++$i) {
            $worksheet = $spreadsheet->getSheet($i);
            $styleWriter->writeTableStyle($worksheet, $i + 1);

            $worksheet->calculateColumnWidths();
            foreach ($worksheet->getColumnDimensions() as $columnDimension) {
                if ($columnDimension->getWidth() !== -1.0) {
                    $styleWriter->writeColumnStyles($columnDimension, $i);
                }
            }
        }
        for ($i = 0; $i < $sheetCount; ++$i) {
            $worksheet = $spreadsheet->getSheet($i);
            foreach ($worksheet->getRowDimensions() as $rowDimension) {
                if ($rowDimension->getRowHeight() > 0.0) {
                    $styleWriter->writeRowStyles($rowDimension, $i);
                }
            }
        }

        foreach ($spreadsheet->getCellXfCollection() as $style) {
            $styleWriter->write($style);
        }
    }

    /**
     * Write attributes for merged cell.
     */
    private function writeCellMerge(XMLWriter $objWriter, Cell $cell): void
    {
        if (!$cell->isMergeRangeValueCell()) {
            return;
        }

        $mergeRange = Coordinate::splitRange((string) $cell->getMergeRange());
        [$startCell, $endCell] = $mergeRange[0];
        $start = Coordinate::coordinateFromString($startCell);
        $end = Coordinate::coordinateFromString($endCell);
        $columnSpan = Coordinate::columnIndexFromString($end[0]) - Coordinate::columnIndexFromString($start[0]) + 1;
        $rowSpan = ((int) $end[1]) - ((int) $start[1]) + 1;

        $objWriter->writeAttribute('table:number-columns-spanned', (string) $columnSpan);
        $objWriter->writeAttribute('table:number-rows-spanned', (string) $rowSpan);
    }
}


1		<?php
2
3		namespace PhpOffice\PhpSpreadsheet\Writer\Ods;
4
5		use Composer\Pcre\Preg;
6		use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
7		use PhpOffice\PhpSpreadsheet\Calculation\Exception as CalculationException;
8		use PhpOffice\PhpSpreadsheet\Cell\Cell;
9		use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
10		use PhpOffice\PhpSpreadsheet\Cell\DataType;
11		use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
12		use PhpOffice\PhpSpreadsheet\Spreadsheet;
13		use PhpOffice\PhpSpreadsheet\Worksheet\RowCellIterator;
14		use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
15		use PhpOffice\PhpSpreadsheet\Writer\Ods;
16		use PhpOffice\PhpSpreadsheet\Writer\Ods\Cell\Comment;
17		use PhpOffice\PhpSpreadsheet\Writer\Ods\Cell\Style;
18
19		/**
20		* @author Alexander Pervakov <[email protected]>
21		*/
22		class Content extends WriterPart
23		{
24		private Formula $formulaConvertor;
25
26		/**
27		* Set parent Ods writer.
28		*/
29	40	public function __construct(Ods $writer)
30		{
31	40	parent::__construct($writer);
32
33	40	$this->formulaConvertor = new Formula($this->getParentWriter()->getSpreadsheet()->getDefinedNames());
34		}
35
36		/**
37		* Write content.xml to XML format.
38		*
39		* @return string XML Output
40		*/
41	39	public function write(): string
42		{
43	39	$objWriter = null;
44	39	if ($this->getParentWriter()->getUseDiskCaching()) {
45		$objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
46		} else {
47	39	$objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
48		}
49
50		// XML header
51	39	$objWriter->startDocument('1.0', 'UTF-8');
52
53		// Content
54	39	$objWriter->startElement('office:document-content');
55	39	$objWriter->writeAttribute('xmlns:office', 'urn:oasis:names:tc:opendocument:xmlns:office:1.0');
56	39	$objWriter->writeAttribute('xmlns:style', 'urn:oasis:names:tc:opendocument:xmlns:style:1.0');
57	39	$objWriter->writeAttribute('xmlns:text', 'urn:oasis:names:tc:opendocument:xmlns:text:1.0');
58	39	$objWriter->writeAttribute('xmlns:table', 'urn:oasis:names:tc:opendocument:xmlns:table:1.0');
59	39	$objWriter->writeAttribute('xmlns:draw', 'urn:oasis:names:tc:opendocument:xmlns:drawing:1.0');
60	39	$objWriter->writeAttribute('xmlns:fo', 'urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0');
61	39	$objWriter->writeAttribute('xmlns:xlink', 'http://www.w3.org/1999/xlink');
62	39	$objWriter->writeAttribute('xmlns:dc', 'http://purl.org/dc/elements/1.1/');
63	39	$objWriter->writeAttribute('xmlns:meta', 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0');
64	39	$objWriter->writeAttribute('xmlns:number', 'urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0');
65	39	$objWriter->writeAttribute('xmlns:presentation', 'urn:oasis:names:tc:opendocument:xmlns:presentation:1.0');
66	39	$objWriter->writeAttribute('xmlns:svg', 'urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0');
67	39	$objWriter->writeAttribute('xmlns:chart', 'urn:oasis:names:tc:opendocument:xmlns:chart:1.0');
68	39	$objWriter->writeAttribute('xmlns:dr3d', 'urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0');
69	39	$objWriter->writeAttribute('xmlns:math', 'http://www.w3.org/1998/Math/MathML');
70	39	$objWriter->writeAttribute('xmlns:form', 'urn:oasis:names:tc:opendocument:xmlns:form:1.0');
71	39	$objWriter->writeAttribute('xmlns:script', 'urn:oasis:names:tc:opendocument:xmlns:script:1.0');
72	39	$objWriter->writeAttribute('xmlns:ooo', 'http://openoffice.org/2004/office');
73	39	$objWriter->writeAttribute('xmlns:ooow', 'http://openoffice.org/2004/writer');
74	39	$objWriter->writeAttribute('xmlns:oooc', 'http://openoffice.org/2004/calc');
75	39	$objWriter->writeAttribute('xmlns:dom', 'http://www.w3.org/2001/xml-events');
76	39	$objWriter->writeAttribute('xmlns:xforms', 'http://www.w3.org/2002/xforms');
77	39	$objWriter->writeAttribute('xmlns:xsd', 'http://www.w3.org/2001/XMLSchema');
78	39	$objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
79	39	$objWriter->writeAttribute('xmlns:rpt', 'http://openoffice.org/2005/report');
80	39	$objWriter->writeAttribute('xmlns:of', 'urn:oasis:names:tc:opendocument:xmlns:of:1.2');
81	39	$objWriter->writeAttribute('xmlns:xhtml', 'http://www.w3.org/1999/xhtml');
82	39	$objWriter->writeAttribute('xmlns:grddl', 'http://www.w3.org/2003/g/data-view#');
83	39	$objWriter->writeAttribute('xmlns:tableooo', 'http://openoffice.org/2009/table');
84	39	$objWriter->writeAttribute('xmlns:field', 'urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0');
85	39	$objWriter->writeAttribute('xmlns:formx', 'urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0');
86	39	$objWriter->writeAttribute('xmlns:css3t', 'http://www.w3.org/TR/css3-text/');
87	39	$objWriter->writeAttribute('office:version', '1.2');
88
89	39	$objWriter->writeElement('office:scripts');
90	39	$objWriter->writeElement('office:font-face-decls');
91
92		// Styles XF
93	39	$objWriter->startElement('office:automatic-styles');
94	39	$this->writeXfStyles($objWriter, $this->getParentWriter()->getSpreadsheet());
95	39	$objWriter->endElement();
96
97	39	$objWriter->startElement('office:body');
98	39	$objWriter->startElement('office:spreadsheet');
99	39	$objWriter->writeElement('table:calculation-settings');
100
101	39	$this->writeSheets($objWriter);
102
103	39	(new AutoFilters($objWriter, $this->getParentWriter()->getSpreadsheet()))->write();
104		// Defined names (ranges and formulae)
105	39	(new NamedExpressions($objWriter, $this->getParentWriter()->getSpreadsheet(), $this->formulaConvertor))->write();
106
107	39	$objWriter->endElement();
108	39	$objWriter->endElement();
109	39	$objWriter->endElement();
110
111	39	return $objWriter->getData();
112		}
113
114		/**
115		* Write sheets.
116		*/
117	39	private function writeSheets(XMLWriter $objWriter): void
118		{
119	39	$spreadsheet = $this->getParentWriter()->getSpreadsheet();
120	39	$sheetCount = $spreadsheet->getSheetCount();
121	39	for ($sheetIndex = 0; $sheetIndex < $sheetCount; ++$sheetIndex) {
122	39	$spreadsheet->getSheet($sheetIndex)->calculateArrays($this->getParentWriter()->getPreCalculateFormulas());
123	39	$objWriter->startElement('table:table');
124	39	$objWriter->writeAttribute('table:name', $spreadsheet->getSheet($sheetIndex)->getTitle());
125	39	$objWriter->writeAttribute('table:style-name', Style::TABLE_STYLE_PREFIX . (string) ($sheetIndex + 1));
126	39	$objWriter->writeElement('office:forms');
127	39	$lastColumn = 0;
128	39	foreach ($spreadsheet->getSheet($sheetIndex)->getColumnDimensions() as $columnDimension) {
129	6	$thisColumn = $columnDimension->getColumnNumeric();
130	6	$emptyColumns = $thisColumn - $lastColumn - 1;
131	6	if ($emptyColumns > 0) {
132	4	$objWriter->startElement('table:table-column');
133	4	$objWriter->writeAttribute('table:number-columns-repeated', (string) $emptyColumns);
134	4	$objWriter->endElement();
135		}
136	6	$lastColumn = $thisColumn;
137	6	$objWriter->startElement('table:table-column');
138	6	$objWriter->writeAttribute(
139	6	'table:style-name',
140	6	sprintf('%s_%d_%d', Style::COLUMN_STYLE_PREFIX, $sheetIndex, $columnDimension->getColumnNumeric())
141	6	);
142	6	$objWriter->writeAttribute('table:default-cell-style-name', 'ce0');
143	6	$objWriter->endElement();
144		}
145	39	$this->writeRows($objWriter, $spreadsheet->getSheet($sheetIndex), $sheetIndex);
146	39	$objWriter->endElement();
147		}
148		}
149
150		/**
151		* Write rows of the specified sheet.
152		*/
153	39	private function writeRows(XMLWriter $objWriter, Worksheet $sheet, int $sheetIndex): void
154		{
155	39	$spanRow = 0;
156	39	$rows = $sheet->getRowIterator();
157	39	foreach ($rows as $row) {
158	39	$cellIterator = $row->getCellIterator(iterateOnlyExistingCells: true);
159	39	$cellIterator->rewind();
160	39	$rowStyleExists = $sheet->rowDimensionExists($row->getRowIndex()) && $sheet->getRowDimension($row->getRowIndex())->getRowHeight() > 0;
161	39	if ($cellIterator->valid() \|\| $rowStyleExists) {
162	37	if ($spanRow) {
163	6	$objWriter->startElement('table:table-row');
164	6	$objWriter->writeAttribute(
165	6	'table:number-rows-repeated',
166	6	(string) $spanRow
167	6	);
168	6	$objWriter->endElement();
169	6	$spanRow = 0;
170		}
171	37	$objWriter->startElement('table:table-row');
172	37	if ($rowStyleExists) {
173	1	$objWriter->writeAttribute(
174	1	'table:style-name',
175	1	sprintf('%s_%d_%d', Style::ROW_STYLE_PREFIX, $sheetIndex, $row->getRowIndex())
176	1	);
177		}
178	37	$this->writeCells($objWriter, $cellIterator);
179	37	$objWriter->endElement();
180		} else {
181	8	++$spanRow;
182		}
183		}
184		}
185
186		/**
187		* Write cells of the specified row.
188		*/
189	37	private function writeCells(XMLWriter $objWriter, RowCellIterator $cells): void
190		{
191	37	$prevColumn = -1;
192	37	foreach ($cells as $cell) {
193		/** @var Cell $cell */
194	37	$column = Coordinate::columnIndexFromString($cell->getColumn()) - 1;
195	37	$attributes = $cell->getFormulaAttributes() ?? [];
196
197	37	$this->writeCellSpan($objWriter, $column, $prevColumn);
198	37	$objWriter->startElement('table:table-cell');
199	37	$this->writeCellMerge($objWriter, $cell);
200
201		// Style XF
202	37	$style = $cell->getXfIndex();
203	37	$objWriter->writeAttribute('table:style-name', Style::CELL_STYLE_PREFIX . $style);
204
205	37	switch ($cell->getDataType()) {
206		case DataType::TYPE_BOOL:
207	3	$objWriter->writeAttribute('office:value-type', 'boolean');
208	3	$objWriter->writeAttribute('office:boolean-value', $cell->getValue() ? 'true' : 'false');
209	3	$objWriter->writeElement('text:p', Calculation::getInstance()->getLocaleBoolean($cell->getValue() ? 'TRUE' : 'FALSE'));
210
211	3	break;
212		case DataType::TYPE_ERROR:
213	1	$objWriter->writeAttribute('table:formula', 'of:=#NULL!');
214	1	$objWriter->writeAttribute('office:value-type', 'string');
215	1	$objWriter->writeAttribute('office:string-value', '');
216	1	$objWriter->writeElement('text:p', '#NULL!');
217
218	1	break;
219		case DataType::TYPE_FORMULA:
220	9	$formulaValue = $cell->getValueString();
221	9	if ($this->getParentWriter()->getPreCalculateFormulas()) {
222		try {
223	8	$formulaValue = $cell->getCalculatedValueString();
224		} catch (CalculationException $e) {
225		// don't do anything
226		}
227		}
228	9	if (isset($attributes['ref'])) {
229	3	if (Preg::isMatch('/^([A-Z]{1,3})([0-9]{1,7})(:([A-Z]{1,3})([0-9]{1,7}))?$/', (string) $attributes['ref'], $matches)) {
230	3	$matrixRowSpan = 1;
231	3	$matrixColSpan = 1;
232	3	if (isset($matches[3])) {
233	3	$minRow = (int) $matches[2];
234	3	$maxRow = (int) $matches[5];
235	3	$matrixRowSpan = $maxRow - $minRow + 1;
236	3	$minCol = Coordinate::columnIndexFromString($matches[1]);
237	3	$maxCol = Coordinate::columnIndexFromString($matches[4]);
238	3	$matrixColSpan = $maxCol - $minCol + 1;
239		}
240	3	$objWriter->writeAttribute('table:number-matrix-columns-spanned', "$matrixColSpan");
241	3	$objWriter->writeAttribute('table:number-matrix-rows-spanned', "$matrixRowSpan");
242		}
243		}
244	9	$objWriter->writeAttribute('table:formula', $this->formulaConvertor->convertFormula($cell->getValueString()));
245	9	if (is_numeric($formulaValue)) {
246	6	$objWriter->writeAttribute('office:value-type', 'float');
247		} else {
248	3	$objWriter->writeAttribute('office:value-type', 'string');
249		}
250	9	$objWriter->writeAttribute('office:value', $formulaValue);
251	9	$objWriter->writeElement('text:p', $formulaValue);
252
253	9	break;
254		case DataType::TYPE_NUMERIC:
255	18	$objWriter->writeAttribute('office:value-type', 'float');
256	18	$objWriter->writeAttribute('office:value', $cell->getValueString());
257	18	$objWriter->writeElement('text:p', $cell->getValueString());
258
259	18	break;
260		case DataType::TYPE_INLINE:
261		// break intentionally omitted
262		case DataType::TYPE_STRING:
263	22	$objWriter->writeAttribute('office:value-type', 'string');
264	22	$url = $cell->getHyperlink()->getUrl();
265	22	if (empty($url)) {
266	22	$objWriter->writeElement('text:p', $cell->getValueString());
267		} else {
268	1	$objWriter->startElement('text:p');
269	1	$objWriter->startElement('text:a');
270	1	$sheets = 'sheet://';
271	1	$lensheets = strlen($sheets);
272	1	if (substr($url, 0, $lensheets) === $sheets) {
273	1	$url = '#' . substr($url, $lensheets);
274		}
275	1	$objWriter->writeAttribute('xlink:href', $url);
276	1	$objWriter->writeAttribute('xlink:type', 'simple');
277	1	$objWriter->text($cell->getValueString());
278	1	$objWriter->endElement(); // text:a
279	1	$objWriter->endElement(); // text:p
280		}
281
282	22	break;
283		}
284	37	Comment::write($objWriter, $cell);
285	37	$objWriter->endElement();
286	37	$prevColumn = $column;
287		}
288		}
289
290		/**
291		* Write span.
292		*/
293	37	private function writeCellSpan(XMLWriter $objWriter, int $curColumn, int $prevColumn): void
294		{
295	37	$diff = $curColumn - $prevColumn - 1;
296	37	if (1 === $diff) {
297	5	$objWriter->writeElement('table:table-cell');
298	36	} elseif ($diff > 1) {
299	4	$objWriter->startElement('table:table-cell');
300	4	$objWriter->writeAttribute('table:number-columns-repeated', (string) $diff);
301	4	$objWriter->endElement();
302		}
303		}
304
305		/**
306		* Write XF cell styles.
307		*/
308	39	private function writeXfStyles(XMLWriter $writer, Spreadsheet $spreadsheet): void
309		{
310	39	$styleWriter = new Style($writer);
311
312	39	$sheetCount = $spreadsheet->getSheetCount();
313	39	for ($i = 0; $i < $sheetCount; ++$i) {
314	39	$worksheet = $spreadsheet->getSheet($i);
315	39	$styleWriter->writeTableStyle($worksheet, $i + 1);
316
317	39	$worksheet->calculateColumnWidths();
318	39	foreach ($worksheet->getColumnDimensions() as $columnDimension) {
319	6	if ($columnDimension->getWidth() !== -1.0) {
320	6	$styleWriter->writeColumnStyles($columnDimension, $i);
321		}
322		}
323		}
324	39	for ($i = 0; $i < $sheetCount; ++$i) {
325	39	$worksheet = $spreadsheet->getSheet($i);
326	39	foreach ($worksheet->getRowDimensions() as $rowDimension) {
327	3	if ($rowDimension->getRowHeight() > 0.0) {
328	1	$styleWriter->writeRowStyles($rowDimension, $i);
329		}
330		}
331		}
332
333	39	foreach ($spreadsheet->getCellXfCollection() as $style) {
334	39	$styleWriter->write($style);
335		}
336		}
337
338		/**
339		* Write attributes for merged cell.
340		*/
341	37	private function writeCellMerge(XMLWriter $objWriter, Cell $cell): void
342		{
343	37	if (!$cell->isMergeRangeValueCell()) {
344	36	return;
345		}
346
347	3	$mergeRange = Coordinate::splitRange((string) $cell->getMergeRange());
348	3	[$startCell, $endCell] = $mergeRange[0];
349	3	$start = Coordinate::coordinateFromString($startCell);
350	3	$end = Coordinate::coordinateFromString($endCell);
351	3	$columnSpan = Coordinate::columnIndexFromString($end[0]) - Coordinate::columnIndexFromString($start[0]) + 1;
352	3	$rowSpan = ((int) $end[1]) - ((int) $start[1]) + 1;
353
354	3	$objWriter->writeAttribute('table:number-columns-spanned', (string) $columnSpan);
355	3	$objWriter->writeAttribute('table:number-rows-spanned', (string) $rowSpan);
356		}
357		}
358

PHPOffice / PhpSpreadsheet

Push — master ( 2661ad...b3452a )

Content::writeRows() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like