public function generate_commodities_excel() { $commodities = Commodities::get_all_with_suppliers(); $column_data = array("Commodity Code", "Commodity Name", "Commodity Source", "Unit Size"); $row_data = array(); foreach ($commodities as $key => $facility_data_item) { array_push($row_data, array($facility_data_item["commodity_code"], $facility_data_item["commodity_name"], $facility_data_item["commodity_source"], $facility_data_item["unit_size"])); } // echo "<pre>";print_r($row_data);exit; $excel_data = array('doc_creator' => "HCMP", 'doc_title' => "HCMP Commodities", 'file_name' => "HCMP Commodities"); $excel_data['column_data'] = $column_data; $excel_data['row_data'] = $row_data; $this->hcmp_functions->create_new_excel($excel_data); }