protected function _fillTheXlsFile($xls, $firstSheet) { $row = $this->_form->getRow(); $this->_progressBar = new Zend_ProgressBar(new Kwf_Util_ProgressBar_Adapter_Cache($this->_getParam('progressNum')), 0, 100); $reporter = new Reporter(); $xls = PHPExcel_IOFactory::load("./templates/flight_task_template.xls"); #$xls->setActiveSheetIndex(); $xls->setActiveSheetIndex(0); $firstSheet = $xls->getActiveSheet(); $sheetId = 0; $firstSheet = $xls->createSheet($sheetId); $reporter->exportFlightTaskToXls($xls, $firstSheet, $row, $this->_progressBar); $this->_progressBar->finish(); return $xls; }