/** * Write the GRIDSET BIFF record. Must be used in conjunction with the * PRINTGRIDLINES record. */ private function _writeGridset() { $record = 0x82; // Record identifier $length = 0x2; // Bytes to follow $fGridSet = !$this->_phpSheet->getPrintGridlines(); // Boolean flag $header = pack("vv", $record, $length); $data = pack("v", $fGridSet); $this->_append($header . $data); }
/** * Write PrintOptions * * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer * @param PHPExcel_Worksheet $pSheet Worksheet * @throws Exception */ private function _writePrintOptions(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) { // printOptions $objWriter->startElement('printOptions'); $objWriter->writeAttribute('gridLines', $pSheet->getPrintGridlines() ? 'true' : 'false'); $objWriter->writeAttribute('gridLinesSet', 'true'); if ($pSheet->getPageSetup()->getHorizontalCentered()) { $objWriter->writeAttribute('horizontalCentered', 'true'); } if ($pSheet->getPageSetup()->getVerticalCentered()) { $objWriter->writeAttribute('verticalCentered', 'true'); } $objWriter->endElement(); }