/** * Write BookViews * * @param \PHPExcel\Shared\XMLWriter $objWriter XML Writer * @param PHPExcel $pPHPExcel * @throws \PHPExcel\Writer\Exception */ private function writeBookViews(\PHPExcel\Shared\XMLWriter $objWriter, \PHPExcel\SpreadSheet $pPHPExcel = null) { // bookViews $objWriter->startElement('bookViews'); // workbookView $objWriter->startElement('workbookView'); $objWriter->writeAttribute('activeTab', $pPHPExcel->getActiveSheetIndex()); $objWriter->writeAttribute('autoFilterDateGrouping', '1'); $objWriter->writeAttribute('firstSheet', '0'); $objWriter->writeAttribute('minimized', '0'); $objWriter->writeAttribute('showHorizontalScroll', '1'); $objWriter->writeAttribute('showSheetTabs', '1'); $objWriter->writeAttribute('showVerticalScroll', '1'); $objWriter->writeAttribute('tabRatio', '600'); $objWriter->writeAttribute('visibility', 'visible'); $objWriter->endElement(); $objWriter->endElement(); }