Advertisement
kurniaif

file excel

Dec 16th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.42 KB | None | 0 0
  1. public function excel()
  2. {
  3. $this->load->helper('exportexcel');
  4. $namaFile = "kematian.xls";
  5. $judul = "kematian";
  6. $tablehead = 0;
  7. $tablebody = 1;
  8. $nourut = 1;
  9. //penulisan header
  10. header("Pragma: public");
  11. header("Expires: 0");
  12. header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
  13. header("Content-Type: application/force-download");
  14. header("Content-Type: application/octet-stream");
  15. header("Content-Type: application/download");
  16. header("Content-Disposition: attachment;filename=" . $namaFile . "");
  17. header("Content-Transfer-Encoding: binary ");
  18.  
  19. xlsBOF();
  20.  
  21. $kolomhead = 0;
  22. xlsWriteLabel($tablehead, $kolomhead++, "No");
  23. xlsWriteLabel($tablehead, $kolomhead++, "Nkkm");
  24. xlsWriteLabel($tablehead, $kolomhead++, "Nikm");
  25. xlsWriteLabel($tablehead, $kolomhead++, "Namam");
  26. xlsWriteLabel($tablehead, $kolomhead++, "Jklkm");
  27. xlsWriteLabel($tablehead, $kolomhead++, "Umurkm");
  28. xlsWriteLabel($tablehead, $kolomhead++, "Pkjaan");
  29. xlsWriteLabel($tablehead, $kolomhead++, "Wktum");
  30. xlsWriteLabel($tablehead, $kolomhead++, "Sbbm");
  31. xlsWriteLabel($tablehead, $kolomhead++, "Tmptm");
  32. xlsWriteLabel($tablehead, $kolomhead++, "Blokm");
  33. xlsWriteLabel($tablehead, $kolomhead++, "Rtm");
  34. xlsWriteLabel($tablehead, $kolomhead++, "Rwm");
  35.  
  36. foreach ($this->Kematian_model->get_all() as $data) {
  37. $kolombody = 0;
  38.  
  39. //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
  40. xlsWriteNumber($tablebody, $kolombody++, $nourut);
  41. xlsWriteLabel($tablebody, $kolombody++, $data->nkkm);
  42. xlsWriteLabel($tablebody, $kolombody++, $data->nikm);
  43. xlsWriteLabel($tablebody, $kolombody++, $data->namam);
  44. xlsWriteLabel($tablebody, $kolombody++, $data->jklkm);
  45. xlsWriteLabel($tablebody, $kolombody++, $data->umurkm);
  46. xlsWriteLabel($tablebody, $kolombody++, $data->pkjaan);
  47. xlsWriteLabel($tablebody, $kolombody++, $data->wktum);
  48. xlsWriteLabel($tablebody, $kolombody++, $data->sbbm);
  49. xlsWriteLabel($tablebody, $kolombody++, $data->tmptm);
  50. xlsWriteLabel($tablebody, $kolombody++, $data->blokm);
  51. xlsWriteLabel($tablebody, $kolombody++, $data->rtm);
  52. xlsWriteLabel($tablebody, $kolombody++, $data->rwm);
  53.  
  54. $tablebody++;
  55. $nourut++;
  56. }
  57.  
  58. xlsEOF();
  59. exit();
  60. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement