Advertisement
Guest User

Untitled

a guest
Sep 16th, 2019
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. public function excel()
  2. {
  3. $data['menu'] = $this->Menu_model->getAllMenu();
  4. require(APPPATH. 'PHPExcel-1.8/Classes/PHPExcel.php');
  5. require(APPPATH. 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');
  6.  
  7. $object = new PHPExcel();
  8.  
  9. $object->getProperties()->setCreator('Hobiholidays');
  10. $object->getProperties()->setLastModifiedBy('Hobiholidays');
  11. $object->getProperties()->setTitle('Daftar Menu');
  12.  
  13. $object->setActiveSheetIndex(0);
  14.  
  15. $object->getActiveSheet()->setCellValue('A1', 'NO');
  16. $object->getActiveSheet()->setCellValue('B1', 'MENU');
  17.  
  18. $baris = 2;
  19. $no = 1;
  20.  
  21. foreach ($data['menu'] as $m) {
  22. $object->getActiveSheet()->setCellValue('A'.$baris, $no++);
  23. $object->getActiveSheet()->setCellValue('B'.$baris, $m['menu']);
  24.  
  25. $baris++;
  26. }
  27.  
  28. $filename = "Data_menu" . '.xlsx';
  29.  
  30. $object->getActiveSheet()->SetTitle('Data Menu');
  31.  
  32. header('Content-Type: application/
  33. vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  34. header('Content-Disposition: attachment;filename="'.$filename.'"');
  35. header('Cache-Control: max-age=0');
  36.  
  37. $writer = PHPExcel_IOFactory::createwriter($object, 'Excel2007');
  38. $writer->save('php://output');
  39.  
  40. exit;
  41.  
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement