/**
* Write SheetViews
*
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
* @param PHPExcel_Worksheet $pSheet Worksheet
* @throws Exception
*/
private function _writeSheetViews(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null)
{
// sheetViews
$objWriter->startElement('sheetViews');
// sheetView
$objWriter->startElement('sheetView');
$objWriter->writeAttribute('tabSelected', '1');
$objWriter->writeAttribute('workbookViewId', '0');
// Gridlines
if ($pSheet->getShowGridlines()) {
$objWriter->writeAttribute('showGridLines', 'true');
}
// Pane
if ($pSheet->getFreezePane() != '') {
// Calculate freeze coordinates
$xSplit = 0;
$ySplit = 0;
$topLeftCell = $pSheet->getFreezePane();
list($xSplit, $ySplit) = PHPExcel_Cell::coordinateFromString($pSheet->getFreezePane());
$xSplit = PHPExcel_Cell::columnIndexFromString($xSplit);
// pane
$objWriter->startElement('pane');
$objWriter->writeAttribute('xSplit', $xSplit - 1);
$objWriter->writeAttribute('ySplit', $ySplit - 1);
$objWriter->writeAttribute('topLeftCell', $topLeftCell);
$objWriter->writeAttribute('activePane', 'bottomRight');
$objWriter->writeAttribute('state', 'frozen');
$objWriter->endElement();
}
// Selection
$objWriter->startElement('selection');
$objWriter->writeAttribute('activeCell', $pSheet->getSelectedCell());
$objWriter->writeAttribute('sqref', $pSheet->getSelectedCell());
$objWriter->endElement();
$objWriter->endElement();
$objWriter->endElement();
}
