Haloo! Selamat Datang di Komunitas Private Training Web Development (47328 Members, 446 Projects, 3621 Topic, 9891 Comments)

Butuh karyawan baru? atau seorang Web Developer (Part-time/Freelance/Full-time), cari disini : Members Area Jobs!
Cara Mengatasi Error di sebuah Aplikasi pada Library PHPExcell
Ivan Jecki Mengatakan : Members -
Rate Topic :
  1. Assalamualaikum Warahmatullahi Wabarakatuh...
  2. Mau tanya mengatasi error ini min
Ada 1 File Kiriman :
1. a1.jpg (79 KB)
Bukhori Muslim Mengatakan :
Admin -
  1. Assalam,.. artinya pada file excel tidak boleh ada yang kosong kolomnya,
  2. ini mau import data ya gan?
  3.  
  4. controller import bikin begini saja :
  5. public function import_excel(){
  6. $config['upload_path'] = 'asset/'.$this->uri->segment(3);
  7. $config['allowed_types'] = 'xlsx|xls';
  8. $this->load->library('upload', $config);
  9. if ( ! $this->upload->do_upload('fileexcel')){
  10. $error = array('error' => $this->upload->display_errors());
  11. }else{
  12. $data = array('upload_data' => $this->upload->data());
  13. $upload_data = $this->upload->data(); //Mengambil detail data yang di upload
  14. $filename = $upload_data['file_name'];//Nama File
  15. $this->model_app->import_excel($this->uri->segment(3),$filename);
  16. redirect('controller_nganu');
  17. }
  18. }
  19.  
  20. Modelsnya begini :
  21. public function import_excel_borongan($directory,$filename){
  22. ini_set('memory_limit', '-1');
  23. $inputFileName = './asset/'.$directory.'/'.$filename;
  24. try {
  25. $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
  26. } catch(Exception $e) {
  27. die('Error loading file :' . $e->getMessage());
  28. }
  29.  
  30. $worksheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
  31. $numRows = count($worksheet);
  32. for ($i=2; $i < ($numRows+1) ; $i++) {
  33. $a = $worksheet[$i]['A'];
  34. $b = $worksheet[$i]['B'];
  35. $c = $worksheet[$i]['C'];
  36. $d = $worksheet[$i]['D'];
  37.  
  38. $data = array('field1'=>$a,
  39. 'field1'=>$b,
  40. 'field1'=>$c,
  41. 'field1'=>$d);
  42. $this->model_app->insert('rb_table',$data);
  43. }
  44. }

Ivan Jecki Mengatakan :
Members -
  1. Assalam,..
  2. itu mau export gan
  3.  

Ivan Jecki Mengatakan :
Members -
  1. Assalam,..
  2. gimna ya gan caranya
  3.  

Bukhori Muslim Mengatakan :
Admin -
  1. Assalam,.. coba sesuaikan dengan ini gan file exportnya :
  2. <?php
  3. //load our new PHPExcel library
  4. $this->load->library('excel');
  5. //activate worksheet number 1
  6. $this->excel->setActiveSheetIndex(0);
  7. //name the worksheet
  8. $this->excel->getActiveSheet()->setTitle('Users list');
  9.  
  10. // load database
  11. $this->load->database();
  12.  
  13. // load model
  14. $this->load->model('userModel');
  15.  
  16. // get all users in array formate
  17. $users = $this->userModel->get_users();
  18.  
  19. // read data to active sheet
  20. $this->excel->getActiveSheet()->fromArray($users);
  21.  
  22. $filename='just_some_random_name.xls'; //save our workbook as this file name
  23. header('Content-Type: application/vnd.ms-excel'); //mime type
  24. header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
  25. header('Cache-Control: max-age=0'); //no cache
  26.  
  27. //save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
  28. //if you want to save it as.XLSX Excel 2007 format
  29. $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
  30.  
  31. //force user to download the Excel file without writing it to server's HD
  32. $objWriter->save('php://output');

Maaf, Untuk Memberikan Komentar Anda Harus Login !!!