/** * Write BookViews * * @param PHPExcel_Shared_XMLWriter $objWriter XML Writer * @param PHPExcel $pPHPExcel * @throws PHPExcel_Writer_Exception */ private function _writeBookViews(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $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(); }