class PHPExcel_Writer_OpenDocument_Content in Loft Data Grids 7.2

Same name and namespace in other branches

6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/OpenDocument/Content.php \PHPExcel_Writer_OpenDocument_Content

PHPExcel_Writer_OpenDocument_Content

Hierarchy

class \PHPExcel_Writer_Excel2007_WriterPart
- class \PHPExcel_Writer_OpenDocument_WriterPart
  - class \PHPExcel_Writer_OpenDocument_Content

Expanded class hierarchy of PHPExcel_Writer_OpenDocument_Content

1 string reference to 'PHPExcel_Writer_OpenDocument_Content'

PHPExcel_Writer_OpenDocument::__construct in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/OpenDocument.php: Create a new PHPExcel_Writer_OpenDocument

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/OpenDocument/Content.php, line 37

View source

class PHPExcel_Writer_OpenDocument_Content extends PHPExcel_Writer_OpenDocument_WriterPart {
  const NUMBER_COLS_REPEATED_MAX = 1024;
  const NUMBER_ROWS_REPEATED_MAX = 1048576;

  /**
   * Write content.xml to XML format
   *
   * @param   PHPExcel                   $pPHPExcel
   * @return  string                     XML Output
   * @throws  PHPExcel_Writer_Exception
   */
  public function write(PHPExcel $pPHPExcel = null) {
    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();
  }

  /**
   * Write sheets
   *
   * @param PHPExcel_Shared_XMLWriter $objWriter
   */
  private function _writeSheets(PHPExcel_Shared_XMLWriter $objWriter) {
    $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();
    }
  }

  /**
   * Write rows of the specified sheet
   *
   * @param PHPExcel_Shared_XMLWriter $objWriter
   * @param PHPExcel_Worksheet $sheet
   */
  private function _writeRows(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet $sheet) {
    $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();
    }
  }

  /**
   * Write cells of the specified row
   *
   * @param PHPExcel_Shared_XMLWriter $objWriter
   * @param PHPExcel_Worksheet_Row $row
   * @throws PHPExcel_Writer_Exception
   */
  private function _writeCells(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet_Row $row) {
    $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');
      }
    }
  }

  /**
   * Write span
   *
   * @param PHPExcel_Shared_XMLWriter $objWriter
   * @param integer $curColumn
   * @param integer $prevColumn
   */
  private function _writeCellSpan(PHPExcel_Shared_XMLWriter $objWriter, $curColumn, $prevColumn) {
    $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();
    }
  }

}

Members

Name	Modifiers	Type	Description
PHPExcel_Writer_Excel2007_WriterPart::$_parentWriter	private	property	* Parent IWriter object * *
PHPExcel_Writer_Excel2007_WriterPart::getParentWriter	public	function	* Get parent IWriter object * *
PHPExcel_Writer_Excel2007_WriterPart::setParentWriter	public	function	* Set parent IWriter object * *
PHPExcel_Writer_Excel2007_WriterPart::__construct	public	function	* Set parent IWriter object * *
PHPExcel_Writer_OpenDocument_Content::NUMBER_COLS_REPEATED_MAX		constant
PHPExcel_Writer_OpenDocument_Content::NUMBER_ROWS_REPEATED_MAX		constant
PHPExcel_Writer_OpenDocument_Content::write	public	function	Write content.xml to XML format
PHPExcel_Writer_OpenDocument_Content::_writeCells	private	function	Write cells of the specified row
PHPExcel_Writer_OpenDocument_Content::_writeCellSpan	private	function	Write span
PHPExcel_Writer_OpenDocument_Content::_writeRows	private	function	Write rows of the specified sheet
PHPExcel_Writer_OpenDocument_Content::_writeSheets	private	function	Write sheets

You are here

class PHPExcel_Writer_OpenDocument_Content in Loft Data Grids 7.2

Hierarchy

File

Members

API Navigation