PHPExcel_Writer_OpenDocument_Content Class Reference

Inheritance diagram for PHPExcel_Writer_OpenDocument_Content:

Collaboration diagram for PHPExcel_Writer_OpenDocument_Content:

Public Member Functions
	write (PHPExcel $pPHPExcel=null)
	Write content.xml to XML format. More...
Public Member Functions inherited from PHPExcel_Writer_Excel2007_WriterPart
	setParentWriter (PHPExcel_Writer_IWriter $pWriter=null)
	Set parent IWriter object. More...
	getParentWriter ()
	Get parent IWriter object. More...
	__construct (PHPExcel_Writer_IWriter $pWriter=null)
	Set parent IWriter object. More...

Data Fields
const	NUMBER_COLS_REPEATED_MAX = 1024
const	NUMBER_ROWS_REPEATED_MAX = 1048576

Private Member Functions
	_writeSheets (PHPExcel_Shared_XMLWriter $objWriter)
	Write sheets. More...
	_writeRows (PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet $sheet)
	Write rows of the specified sheet. More...
	_writeCells (PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet_Row $row)
	Write cells of the specified row. More...
	_writeCellSpan (PHPExcel_Shared_XMLWriter $objWriter, $curColumn, $prevColumn)
	Write span. More...

Detailed Description

Definition at line 37 of file Content.php.

Member Function Documentation

_writeCells()

PHPExcel_Writer_OpenDocument_Content::_writeCells ( PHPExcel_Shared_XMLWriter  $objWriter, PHPExcel_Worksheet_Row  $row  )

private

Write cells of the specified row.

Parameters

PHPExcel_Shared_XMLWriter	$objWriter
PHPExcel_Worksheet_Row	$row

Exceptions

PHPExcel_Writer_Exception

Definition at line 183 of file Content.php.

References $column, _writeCellSpan(), PHPExcel_Cell\columnIndexFromString(), PHPExcel_Worksheet_Row\getCellIterator(), PHPExcel_Cell_DataType\TYPE_BOOL, PHPExcel_Cell_DataType\TYPE_ERROR, PHPExcel_Cell_DataType\TYPE_FORMULA, PHPExcel_Cell_DataType\TYPE_INLINE, PHPExcel_Cell_DataType\TYPE_NUMERIC, PHPExcel_Cell_DataType\TYPE_STRING, and PHPExcel_Writer_OpenDocument_Cell_Comment\write().

Referenced by _writeRows().

    {
        $number_cols_repeated = self::NUMBER_COLS_REPEATED_MAX;
        $prev_column = -1;
        $cells = $row->getCellIterator();
        while ($cells->valid()) {
            $cell = $cells->current();
            $column = PHPExcel_Cell::columnIndexFromString($cell->getColumn()) - 1;

            $this->_writeCellSpan($objWriter, $column, $prev_column);
            $objWriter->startElement('table:table-cell');

            switch ($cell->getDataType()) {
                case PHPExcel_Cell_DataType::TYPE_BOOL:
                    $objWriter->writeAttribute('office:value-type', 'boolean');
                    $objWriter->writeAttribute('office:value', $cell->getValue());
                    $objWriter->writeElement('text:p', $cell->getValue());
                    break;

                case PHPExcel_Cell_DataType::TYPE_ERROR:
                    throw new PHPExcel_Writer_Exception('Writing of error not implemented yet.');
                    break;

                case PHPExcel_Cell_DataType::TYPE_FORMULA:
                    try {
                        $formula_value = $cell->getCalculatedValue();
                    } catch (Exception $e) {
                        $formula_value = $cell->getValue();
                    }
                    $objWriter->writeAttribute('table:formula', 'of:' . $cell->getValue());
                    if (is_numeric($formula_value)) {
                        $objWriter->writeAttribute('office:value-type', 'float');
                    } else {
                        $objWriter->writeAttribute('office:value-type', 'string');
                    }
                    $objWriter->writeAttribute('office:value', $formula_value);
                    $objWriter->writeElement('text:p', $formula_value);
                    break;

                case PHPExcel_Cell_DataType::TYPE_INLINE:
                    throw new PHPExcel_Writer_Exception('Writing of inline not implemented yet.');
                    break;

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

                case PHPExcel_Cell_DataType::TYPE_STRING:
                    $objWriter->writeAttribute('office:value-type', 'string');
                    $objWriter->writeElement('text:p', $cell->getValue());
                    break;
            }
            PHPExcel_Writer_OpenDocument_Cell_Comment::write($objWriter, $cell);
            $objWriter->endElement();
            $prev_column = $column;
            $cells->next();
        }
        $number_cols_repeated = $number_cols_repeated - $prev_column - 1;
        if ($number_cols_repeated > 0) {
            if ($number_cols_repeated > 1) {
                $objWriter->startElement('table:table-cell');
                $objWriter->writeAttribute('table:number-columns-repeated', $number_cols_repeated);
                $objWriter->endElement();
            } else {
                $objWriter->writeElement('table:table-cell');
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_writeCellSpan()

PHPExcel_Writer_OpenDocument_Content::_writeCellSpan ( PHPExcel_Shared_XMLWriter  $objWriter,   $curColumn,   $prevColumn  )

private

Write span.

Parameters

PHPExcel_Shared_XMLWriter	$objWriter
integer	$curColumn
integer	$prevColumn

Definition at line 261 of file Content.php.

Referenced by _writeCells().

    {
        $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', $diff);
            $objWriter->endElement();
        }
    }

Here is the caller graph for this function:

_writeRows()

PHPExcel_Writer_OpenDocument_Content::_writeRows ( PHPExcel_Shared_XMLWriter  $objWriter, PHPExcel_Worksheet  $sheet  )

private

Write rows of the specified sheet.

Parameters

PHPExcel_Shared_XMLWriter	$objWriter
PHPExcel_Worksheet	$sheet

Definition at line 146 of file Content.php.

References $row, $rows, _writeCells(), and PHPExcel_Worksheet\getRowIterator().

Referenced by _writeSheets().

    {
        $number_rows_repeated = self::NUMBER_ROWS_REPEATED_MAX;
        $span_row = 0;
        $rows = $sheet->getRowIterator();
        while ($rows->valid()) {
            $number_rows_repeated--;
            $row = $rows->current();
            if ($row->getCellIterator()->valid()) {
                if ($span_row) {
                    $objWriter->startElement('table:table-row');
                    if ($span_row > 1) {
                        $objWriter->writeAttribute('table:number-rows-repeated', $span_row);
                    }
                    $objWriter->startElement('table:table-cell');
                        $objWriter->writeAttribute('table:number-columns-repeated', self::NUMBER_COLS_REPEATED_MAX);
                    $objWriter->endElement();
                    $objWriter->endElement();
                    $span_row = 0;
                }
                $objWriter->startElement('table:table-row');
                $this->_writeCells($objWriter, $row);
                $objWriter->endElement();
            } else {
                $span_row++;
            }
            $rows->next();
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_writeSheets()

PHPExcel_Writer_OpenDocument_Content::_writeSheets ( PHPExcel_Shared_XMLWriter  $objWriter )

private

Write sheets.

Parameters

PHPExcel_Shared_XMLWriter

$objWriter

Definition at line 122 of file Content.php.

References $i, _writeRows(), and PHPExcel_Writer_Excel2007_WriterPart\getParentWriter().

Referenced by write().

    {
        $pPHPExcel = $this->getParentWriter()->getPHPExcel(); /* @var $pPHPExcel PHPExcel */

        $sheet_count = $pPHPExcel->getSheetCount();
        for ($i = 0; $i < $sheet_count; $i++) {
            //$this->getWriterPart('Worksheet')->writeWorksheet());
            $objWriter->startElement('table:table');
                $objWriter->writeAttribute('table:name', $pPHPExcel->getSheet($i)->getTitle());
                $objWriter->writeElement('office:forms');
                $objWriter->startElement('table:table-column');
                    $objWriter->writeAttribute('table:number-columns-repeated', self::NUMBER_COLS_REPEATED_MAX);
                $objWriter->endElement();
                $this->_writeRows($objWriter, $pPHPExcel->getSheet($i));
            $objWriter->endElement();
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

write()

PHPExcel_Writer_OpenDocument_Content::write

(

PHPExcel

$pPHPExcel = null

)

Write content.xml to XML format.

Parameters

PHPExcel

$pPHPExcel

Returns

string XML Output

Exceptions

PHPExcel_Writer_Exception

Definition at line 49 of file Content.php.

References $objWriter, _writeSheets(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

    {
        if (!$pPHPExcel) {
            $pPHPExcel = $this->getParentWriter()->getPHPExcel(); /* @var $pPHPExcel PHPExcel */
        }

        $objWriter = null;
        if ($this->getParentWriter()->getUseDiskCaching()) {
            $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
        } else {
            $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_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');
            $objWriter->writeElement('office:automatic-styles');

            $objWriter->startElement('office:body');
                $objWriter->startElement('office:spreadsheet');
                    $objWriter->writeElement('table:calculation-settings');
                    $this->_writeSheets($objWriter);
                    $objWriter->writeElement('table:named-expressions');
                $objWriter->endElement();
            $objWriter->endElement();
        $objWriter->endElement();

        return $objWriter->getData();
    }

Here is the call graph for this function:

Field Documentation

NUMBER_COLS_REPEATED_MAX

const PHPExcel_Writer_OpenDocument_Content::NUMBER_COLS_REPEATED_MAX = 1024

Definition at line 39 of file Content.php.

NUMBER_ROWS_REPEATED_MAX

const PHPExcel_Writer_OpenDocument_Content::NUMBER_ROWS_REPEATED_MAX = 1048576

Definition at line 40 of file Content.php.

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/OpenDocument/Content.php