public function PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet()

* Write worksheet to XML format * *

Parameters

PHPExcel_Worksheet $pSheet: * @param string[] $pStringTable * @param boolean $includeCharts Flag indicating if we should write charts * @return string XML Output * @throws PHPExcel_Writer_Exception

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php, line 47

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

public function writeWorksheet($pSheet = null, $pStringTable = null, $includeCharts = FALSE) {
  if (!is_null($pSheet)) {

    // Create XML writer
    $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', 'yes');

    // Worksheet
    $objWriter
      ->startElement('worksheet');
    $objWriter
      ->writeAttribute('xml:space', 'preserve');
    $objWriter
      ->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
    $objWriter
      ->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');

    // sheetPr
    $this
      ->_writeSheetPr($objWriter, $pSheet);

    // Dimension
    $this
      ->_writeDimension($objWriter, $pSheet);

    // sheetViews
    $this
      ->_writeSheetViews($objWriter, $pSheet);

    // sheetFormatPr
    $this
      ->_writeSheetFormatPr($objWriter, $pSheet);

    // cols
    $this
      ->_writeCols($objWriter, $pSheet);

    // sheetData
    $this
      ->_writeSheetData($objWriter, $pSheet, $pStringTable);

    // sheetProtection
    $this
      ->_writeSheetProtection($objWriter, $pSheet);

    // protectedRanges
    $this
      ->_writeProtectedRanges($objWriter, $pSheet);

    // autoFilter
    $this
      ->_writeAutoFilter($objWriter, $pSheet);

    // mergeCells
    $this
      ->_writeMergeCells($objWriter, $pSheet);

    // conditionalFormatting
    $this
      ->_writeConditionalFormatting($objWriter, $pSheet);

    // dataValidations
    $this
      ->_writeDataValidations($objWriter, $pSheet);

    // hyperlinks
    $this
      ->_writeHyperlinks($objWriter, $pSheet);

    // Print options
    $this
      ->_writePrintOptions($objWriter, $pSheet);

    // Page margins
    $this
      ->_writePageMargins($objWriter, $pSheet);

    // Page setup
    $this
      ->_writePageSetup($objWriter, $pSheet);

    // Header / footer
    $this
      ->_writeHeaderFooter($objWriter, $pSheet);

    // Breaks
    $this
      ->_writeBreaks($objWriter, $pSheet);

    // Drawings and/or Charts
    $this
      ->_writeDrawings($objWriter, $pSheet, $includeCharts);

    // LegacyDrawing
    $this
      ->_writeLegacyDrawing($objWriter, $pSheet);

    // LegacyDrawingHF
    $this
      ->_writeLegacyDrawingHF($objWriter, $pSheet);
    $objWriter
      ->endElement();

    // Return
    return $objWriter
      ->getData();
  }
  else {
    throw new PHPExcel_Writer_Exception("Invalid PHPExcel_Worksheet object passed.");
  }
}