Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function excel()
- {
- $this->load->helper('exportexcel');
- $namaFile = "kematian.xls";
- $judul = "kematian";
- $tablehead = 0;
- $tablebody = 1;
- $nourut = 1;
- //penulisan header
- header("Pragma: public");
- header("Expires: 0");
- header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
- header("Content-Type: application/force-download");
- header("Content-Type: application/octet-stream");
- header("Content-Type: application/download");
- header("Content-Disposition: attachment;filename=" . $namaFile . "");
- header("Content-Transfer-Encoding: binary ");
- xlsBOF();
- $kolomhead = 0;
- xlsWriteLabel($tablehead, $kolomhead++, "No");
- xlsWriteLabel($tablehead, $kolomhead++, "Nkkm");
- xlsWriteLabel($tablehead, $kolomhead++, "Nikm");
- xlsWriteLabel($tablehead, $kolomhead++, "Namam");
- xlsWriteLabel($tablehead, $kolomhead++, "Jklkm");
- xlsWriteLabel($tablehead, $kolomhead++, "Umurkm");
- xlsWriteLabel($tablehead, $kolomhead++, "Pkjaan");
- xlsWriteLabel($tablehead, $kolomhead++, "Wktum");
- xlsWriteLabel($tablehead, $kolomhead++, "Sbbm");
- xlsWriteLabel($tablehead, $kolomhead++, "Tmptm");
- xlsWriteLabel($tablehead, $kolomhead++, "Blokm");
- xlsWriteLabel($tablehead, $kolomhead++, "Rtm");
- xlsWriteLabel($tablehead, $kolomhead++, "Rwm");
- foreach ($this->Kematian_model->get_all() as $data) {
- $kolombody = 0;
- //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
- xlsWriteNumber($tablebody, $kolombody++, $nourut);
- xlsWriteLabel($tablebody, $kolombody++, $data->nkkm);
- xlsWriteLabel($tablebody, $kolombody++, $data->nikm);
- xlsWriteLabel($tablebody, $kolombody++, $data->namam);
- xlsWriteLabel($tablebody, $kolombody++, $data->jklkm);
- xlsWriteLabel($tablebody, $kolombody++, $data->umurkm);
- xlsWriteLabel($tablebody, $kolombody++, $data->pkjaan);
- xlsWriteLabel($tablebody, $kolombody++, $data->wktum);
- xlsWriteLabel($tablebody, $kolombody++, $data->sbbm);
- xlsWriteLabel($tablebody, $kolombody++, $data->tmptm);
- xlsWriteLabel($tablebody, $kolombody++, $data->blokm);
- xlsWriteLabel($tablebody, $kolombody++, $data->rtm);
- xlsWriteLabel($tablebody, $kolombody++, $data->rwm);
- $tablebody++;
- $nourut++;
- }
- xlsEOF();
- exit();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement