Content::writeCells() - Code Metrics - Inspection of "Merge pull request #3352 from PHPOffice/PR3329-Add..." - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 5fb76c...11bae5 )

by Mark

created 2023-02-07 19:43 UTC

Content::writeCells() C

↳ Parent: Content

Complexity

Conditions	14
Paths	75

Size

Total Lines	78
Code Lines	57

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	47
CRAP Score	14.0133

Importance

Changes

Metric	Value
eloc	57
c	0
b	0
f	0
dl	0
loc	78
ccs	47
cts	49
cp	0.9592
rs	6.2666
cc	14
nc	75
nop	2
crap	14.0133

How to fix Long Method Complexity

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Ods;

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\Row;
use PhpOffice\PhpSpreadsheet\Worksheet\RowCellIterator;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Writer\Exception;
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
{
    const NUMBER_COLS_REPEATED_MAX = 1024;
    const NUMBER_ROWS_REPEATED_MAX = 1048576;

    /** @var Formula */
    private $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(); /** @var Spreadsheet $spreadsheet */
        $sheetCount = $spreadsheet->getSheetCount();
        for ($sheetIndex = 0; $sheetIndex < $sheetCount; ++$sheetIndex) {
            $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');
            foreach ($spreadsheet->getSheet($sheetIndex)->getColumnDimensions() as $columnDimension) {
                $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->writeAttribute('table:number-columns-repeated', self::NUMBER_COLS_REPEATED_MAX);
                $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
    {
        $numberRowsRepeated = self::NUMBER_ROWS_REPEATED_MAX;
        $span_row = 0;
        $rows = $sheet->getRowIterator();
        foreach ($rows as $row) {
            $cellIterator = $row->getCellIterator();
            --$numberRowsRepeated;
            if ($cellIterator->valid()) {
                $objWriter->startElement('table:table-row');
                if ($span_row) {
                    if ($span_row > 1) {
                        $objWriter->writeAttribute('table:number-rows-repeated', (string) $span_row);
                    }
                    $objWriter->startElement('table:table-cell');
                    $objWriter->writeAttribute('table:number-columns-repeated', (string) self::NUMBER_COLS_REPEATED_MAX);
                    $objWriter->endElement();
                    $span_row = 0;
                } else {
                    if ($sheet->getRowDimension($row->getRowIndex())->getRowHeight() > 0) {
                        $objWriter->writeAttribute(
                            'table:style-name',
                            sprintf('%s_%d_%d', Style::ROW_STYLE_PREFIX, $sheetIndex, $row->getRowIndex())
                        );
                    }
                    $this->writeCells($objWriter, $cellIterator);
                }
                $objWriter->endElement();
            } else {
                ++$span_row;
            }
        }
    }

    /**
     * Write cells of the specified row.
     */
    private function writeCells(XMLWriter $objWriter, RowCellIterator $cells): void
    {
        $numberColsRepeated = self::NUMBER_COLS_REPEATED_MAX;
        $prevColumn = -1;
        foreach ($cells as $cell) {
            /** @var \PhpOffice\PhpSpreadsheet\Cell\Cell $cell */
            $column = Coordinate::columnIndexFromString($cell->getColumn()) - 1;

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

            // Style XF
            $style = $cell->getXfIndex();
            if ($style !== null) {
                $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:value', $cell->getValue());
                    $objWriter->writeElement('text:p', $cell->getValue());

                    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->getValue();
                    if ($this->getParentWriter()->getPreCalculateFormulas()) {
                        try {
                            $formulaValue = $cell->getCalculatedValue();
                        } catch (Exception $e) {
                            // don't do anything
                        }
                    }
                    $objWriter->writeAttribute('table:formula', $this->formulaConvertor->convertFormula($cell->getValue()));
                    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->getValue());
                    $objWriter->writeElement('text:p', $cell->getValue());

                    break;
                case DataType::TYPE_INLINE:
                    // break intentionally omitted
                case DataType::TYPE_STRING:
                    $objWriter->writeAttribute('office:value-type', 'string');
                    $objWriter->writeElement('text:p', $cell->getValue());

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

        $numberColsRepeated = $numberColsRepeated - $prevColumn - 1;
        if ($numberColsRepeated > 0) {
            if ($numberColsRepeated > 1) {
                $objWriter->startElement('table:table-cell');
                $objWriter->writeAttribute('table:number-columns-repeated', (string) $numberColsRepeated);
                $objWriter->endElement();
            } else {
                $objWriter->writeElement('table:table-cell');
            }
        }
    }

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

PHPOffice / PhpSpreadsheet

Push — master ( 5fb76c...11bae5 )

Content::writeCells() C

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like