private function PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr 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::_writeSheetPr()
* Write SheetPr * *
Parameters
PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception
1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr()
- PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php - * Write worksheet to XML format * *
File
- vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php, line 146
Class
- PHPExcel_Writer_Excel2007_Worksheet
- PHPExcel_Writer_Excel2007_Worksheet
Code
private function _writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {
// sheetPr
$objWriter
->startElement('sheetPr');
//$objWriter->writeAttribute('codeName', $pSheet->getTitle());
if ($pSheet
->getParent()
->hasMacros()) {
//if the workbook have macros, we need to have codeName for the sheet
if ($pSheet
->hasCodeName() == false) {
$pSheet
->setCodeName($pSheet
->getTitle());
}
$objWriter
->writeAttribute('codeName', $pSheet
->getCodeName());
}
$autoFilterRange = $pSheet
->getAutoFilter()
->getRange();
if (!empty($autoFilterRange)) {
$objWriter
->writeAttribute('filterMode', 1);
$pSheet
->getAutoFilter()
->showHideRows();
}
// tabColor
if ($pSheet
->isTabColorSet()) {
$objWriter
->startElement('tabColor');
$objWriter
->writeAttribute('rgb', $pSheet
->getTabColor()
->getARGB());
$objWriter
->endElement();
}
// outlinePr
$objWriter
->startElement('outlinePr');
$objWriter
->writeAttribute('summaryBelow', $pSheet
->getShowSummaryBelow() ? '1' : '0');
$objWriter
->writeAttribute('summaryRight', $pSheet
->getShowSummaryRight() ? '1' : '0');
$objWriter
->endElement();
// pageSetUpPr
if ($pSheet
->getPageSetup()
->getFitToPage()) {
$objWriter
->startElement('pageSetUpPr');
$objWriter
->writeAttribute('fitToPage', '1');
$objWriter
->endElement();
}
$objWriter
->endElement();
}