/** * Create a new worksheet * * @param PHPExcel $pParent * @param string $pTitle */ public function __construct(PHPExcel $pParent = null, $pTitle = 'Worksheet') { // Set parent and title $this->_parent = $pParent; $this->setTitle($pTitle, FALSE); // setTitle can change $pTitle $this->setCodeName($this->getTitle()); $this->setSheetState(PHPExcel_Worksheet::SHEETSTATE_VISIBLE); $this->_cellCollection = PHPExcel_CachedObjectStorageFactory::getInstance($this); // Set page setup $this->_pageSetup = new PHPExcel_Worksheet_PageSetup(); // Set page margins $this->_pageMargins = new PHPExcel_Worksheet_PageMargins(); // Set page header/footer $this->_headerFooter = new PHPExcel_Worksheet_HeaderFooter(); // Set sheet view $this->_sheetView = new PHPExcel_Worksheet_SheetView(); // Drawing collection $this->_drawingCollection = new ArrayObject(); // Chart collection $this->_chartCollection = new ArrayObject(); // Protection $this->_protection = new PHPExcel_Worksheet_Protection(); // Default row dimension $this->_defaultRowDimension = new PHPExcel_Worksheet_RowDimension(NULL); // Default column dimension $this->_defaultColumnDimension = new PHPExcel_Worksheet_ColumnDimension(NULL); $this->_autoFilter = new PHPExcel_Worksheet_AutoFilter(NULL, $this); }
/** * Create a new worksheet * * @param PHPExcel $pParent * @param string $pTitle */ public function __construct(PHPExcel $pParent = null, $pTitle = 'Worksheet') { // Set parent and title $this->_parent = $pParent; $this->setTitle($pTitle); $this->setSheetState(PHPExcel_Worksheet::SHEETSTATE_VISIBLE); $this->_cellCollection = PHPExcel_CachedObjectStorageFactory::getInstance($this); // Set page setup $this->_pageSetup = new PHPExcel_Worksheet_PageSetup(); // Set page margins $this->_pageMargins = new PHPExcel_Worksheet_PageMargins(); // Set page header/footer $this->_headerFooter = new PHPExcel_Worksheet_HeaderFooter(); // Set sheet view $this->_sheetView = new PHPExcel_Worksheet_SheetView(); // Drawing collection $this->_drawingCollection = new ArrayObject(); // Protection $this->_protection = new PHPExcel_Worksheet_Protection(); // Gridlines $this->_showGridlines = true; $this->_printGridlines = false; // Outline summary $this->_showSummaryBelow = true; $this->_showSummaryRight = true; // Default row dimension $this->_defaultRowDimension = new PHPExcel_Worksheet_RowDimension(null); // Default column dimension $this->_defaultColumnDimension = new PHPExcel_Worksheet_ColumnDimension(null); }