public function exportExcelAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $export_array = array(); $stock_master = new Model_StockMaster(); $stock_master->form_values['searchby'] = $this->_request->searchby; $stock_master->form_values['number'] = $this->_request->number; $stock_master->form_values['warehouses'] = $this->_request->warehouses; $stock_master->form_values['product'] = $this->_request->product; $stock_master->form_values['date_from'] = $this->_request->date_from; $stock_master->form_values['date_to'] = $this->_request->date_to; $data = $stock_master->getTempStockIssue(); array_push($export_array, array("Item Name", "Transaction Date", "Transaction Number", "Transaction Reference", "Warehouse Name", "Batch no.", "Expiry date", "Quantity", "Item Unit", "Doses per vial", "Total doses", "VVM Stage")); foreach ($data as $row) { array_push($export_array, array($row['itemName'], $row['transactionDate'], $row['transactionNumber'], $row['transactionReference'], $row['warehouseName'], $row['number'], $row['expiryDate'], $row['quantity'], $row['itemUnitName'], $row['description'], $row['quantity'] * $row['description'], $row['vvmStageValue'])); } // generate file (constructor parameters are optional) $xls = new App_PhpExcel('UTF-8', false, 'Issue List'); $xls->addArray($export_array); $xls->generateXML('issue-list'); }