private function PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea in Loft Data Grids 7.2
Same name and namespace in other branches
- 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Workbook.php \PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea()
* Write Defined Name for PrintTitles * *
Parameters
PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet * @param int $pSheetId * @throws PHPExcel_Writer_Exception
1 call to PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea()
- PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNames in vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Workbook.php - * Write Defined Names * *
File
- vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Workbook.php, line 430
Class
- PHPExcel_Writer_Excel2007_Workbook
- PHPExcel_Writer_Excel2007_Workbook
Code
private function _writeDefinedNameForPrintArea(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pSheetId = 0) {
// definedName for PrintArea
if ($pSheet
->getPageSetup()
->isPrintAreaSet()) {
$objWriter
->startElement('definedName');
$objWriter
->writeAttribute('name', '_xlnm.Print_Area');
$objWriter
->writeAttribute('localSheetId', $pSheetId);
// Setting string
$settingString = '';
// Print area
$printArea = PHPExcel_Cell::splitRange($pSheet
->getPageSetup()
->getPrintArea());
$chunks = array();
foreach ($printArea as $printAreaRect) {
$printAreaRect[0] = PHPExcel_Cell::absoluteReference($printAreaRect[0]);
$printAreaRect[1] = PHPExcel_Cell::absoluteReference($printAreaRect[1]);
$chunks[] = '\'' . str_replace("'", "''", $pSheet
->getTitle()) . '\'!' . implode(':', $printAreaRect);
}
$objWriter
->writeRawData(implode(',', $chunks));
$objWriter
->endElement();
}
}