php

 public function export_data()
    {
        # code...
        $data["export"] = $this->mod->data_excel();
        $this->load->model("M_Deposit_transaction");
        $this->load->library("excel");
        $object = new PHPExcel();
        $object->setActiveSheetIndex(0);
        $table_columns = array("Tgl Trx", "Kode","Agen","Pengirim","Penerima","Nominal","Status");
        $column = 0;

          foreach($table_columns as $field){

            $object->getActiveSheet()->setCellValueByColumnAndRow($column, 1, $field);

            $column++;

          }

        $employee_data = $this->M_Deposit_transaction->data_excel();
        $excel_row = 2;
          foreach($employee_data as $row){

            $object->getActiveSheet()->setCellValueByColumnAndRow(0, $excel_row, $row->name);

            $object->getActiveSheet()->setCellValueByColumnAndRow(1, $excel_row, $row->email);

            $excel_row++;

          }

        $object_writer = PHPExcel_IOFactory::createWriter($object, 'Excel5');
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="Rekap Transaksi Data.xls"');
        $object_writer->save('php://output');
    }