public function PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in Loft Data Grids 6.2
Same name and namespace in other branches
- 7.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.");
}
}