Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function excel()
- {
- $data['menu'] = $this->Menu_model->getAllMenu();
- require(APPPATH. 'PHPExcel-1.8/Classes/PHPExcel.php');
- require(APPPATH. 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');
- $object = new PHPExcel();
- $object->getProperties()->setCreator('Hobiholidays');
- $object->getProperties()->setLastModifiedBy('Hobiholidays');
- $object->getProperties()->setTitle('Daftar Menu');
- $object->setActiveSheetIndex(0);
- $object->getActiveSheet()->setCellValue('A1', 'NO');
- $object->getActiveSheet()->setCellValue('B1', 'MENU');
- $baris = 2;
- $no = 1;
- foreach ($data['menu'] as $m) {
- $object->getActiveSheet()->setCellValue('A'.$baris, $no++);
- $object->getActiveSheet()->setCellValue('B'.$baris, $m['menu']);
- $baris++;
- }
- $filename = "Data_menu" . '.xlsx';
- $object->getActiveSheet()->SetTitle('Data Menu');
- header('Content-Type: application/
- vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment;filename="'.$filename.'"');
- header('Cache-Control: max-age=0');
- $writer = PHPExcel_IOFactory::createwriter($object, 'Excel2007');
- $writer->save('php://output');
- exit;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement