{"id":1634,"date":"2017-06-14T11:53:00","date_gmt":"2017-06-14T06:23:00","guid":{"rendered":"https:\/\/blog.pheonixsolutions.com\/?p=1634"},"modified":"2017-06-14T11:53:00","modified_gmt":"2017-06-14T06:23:00","slug":"codeigniter-importing-data-using-excel-file","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/codeigniter-importing-data-using-excel-file\/","title":{"rendered":"codeigniter importing data using excel file"},"content":{"rendered":"

Date Posted:14-06-2017<\/strong>
\nIn this post\u00a0 we will explain codeigniter importing data using excel file and PHPExcel libary
\nI assume that you are configure or setup the codeigniter<\/p>\n

step1:Download PHPExcel libarry from it\u2019s github repository or you can download it from PHPExcel official website.
\nDwonload PHPExcel library
\nDwonload PHPExcel library from GIThub repository from\u00a0https:\/\/phpexcel.codeplex.com\/<\/a><\/p>\n

Step2:<\/p>\n

After download you find three differnt folder Classes,Documentation,Examples in PHPExcel.navigate to application\/thirdparty extract PHPExcel->Classes->PHPExcel.php and PHPExcel directory directory here.<\/p>\n

Step3:
\nNavigate to application\/libraries and create new file name as ExcelImport_lib.php,place following code here<\/p>\n

<?php\r\n if ( ! defined('BASEPATH')) exit('No direct script access allowed'); \r\n ini_set('error_reporting', E_STRICT); \r\n require_once APPPATH.\"\/third_party\/PHPExcel.php\"; \r\n class ExcelImport_lib extends PHPExcel \r\n { public function __construct() \r\n \t{ parent::__construct(); } \r\n } ?><\/pre>\n
Step4:
\nNavigate to application\/controllers and create new file name as ImportExcel.php,place following code here<\/p>\n
<?php\r\nif ( ! defined('BASEPATH')) exit('No direct script access allowed'); \r\n\/**\r\n * summary\r\n *\/\r\nclass ImportExcel extends CI_Controller\r\n{\r\n    public function index()\r\n    {\r\n    \t$this->load->view('excelimport');\t\r\n    }\r\n    public function Import($value='')\r\n    {\r\n        $this->load->library('ExcelImport_lib');\r\n \t\t\t\r\n     try {\r\n    \/\/\/ it will be your file name that you are posting with a form or can pass static name $_FILES[\"file\"][\"name\"];\r\n     \t\/\/ $objPHPExcel = PHPExcel_IOFactory::load('uploads\/'.$_FILES[\"file\"][\"name\"]);\r\n     \t$objPHPExcel = PHPExcel_IOFactory::load('uploads\/'.'yourTableName.xls');\r\n\r\n         }\r\n     catch(Exception $e)\r\n        {\r\n           $this->resp->success = FALSE;\r\n           $this->resp->msg = 'Error Uploading file';\r\n           echo json_encode($this->resp);\r\n           exit;\r\n        }\r\n\r\n     $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);\r\n     print_r($allDataInSheet);\r\n    foreach($allDataInSheet as $import)\r\n    {\r\n      echo $import['A']; \/\/\/ will return values of Col A\r\n      echo $import['B']; \/\/\/ will return values of Col B\r\n      echo $import['C']; \/\/\/ will return values of Col C\r\n      echo $import['D']; \/\/\/ will return values of Col D\r\n\r\n    }\r\n    }\r\n}\r\n\r\n?><\/pre>\n
Step5:
\nNavigate to application\/view and create new file name as excelimport.php,place following code here<\/p>\n
<?php\r\ndefined('BASEPATH') OR exit('No direct script access allowed');\r\n?><!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n  <meta charset=\"utf-8\">\r\n  <title>Welcome to CodeIgniter<\/title>\r\n\r\n  <style type=\"text\/css\">\r\n\r\n  ::selection { background-color: #E13300; color: white; }\r\n  ::-moz-selection { background-color: #E13300; color: white; }\r\n\r\n  body {\r\n    background-color: #fff;\r\n    margin: 40px;\r\n    font: 13px\/20px normal Helvetica, Arial, sans-serif;\r\n    color: #4F5155;\r\n  }\r\n\r\n  a {\r\n    color: #003399;\r\n    background-color: transparent;\r\n    font-weight: normal;\r\n  }\r\n\r\n  h1 {\r\n    color: #444;\r\n    background-color: transparent;\r\n    border-bottom: 1px solid #D0D0D0;\r\n    font-size: 19px;\r\n    font-weight: normal;\r\n    margin: 0 0 14px 0;\r\n    padding: 14px 15px 10px 15px;\r\n  }\r\n\r\n  code {\r\n    font-family: Consolas, Monaco, Courier New, Courier, monospace;\r\n    font-size: 12px;\r\n    background-color: #f9f9f9;\r\n    border: 1px solid #D0D0D0;\r\n    color: #002166;\r\n    display: block;\r\n    margin: 14px 0 14px 0;\r\n    padding: 12px 10px 12px 10px;\r\n  }\r\n\r\n  #body {\r\n    margin: 0 15px 0 15px;\r\n  }\r\n\r\n  p.footer {\r\n    text-align: right;\r\n    font-size: 11px;\r\n    border-top: 1px solid #D0D0D0;\r\n    line-height: 32px;\r\n    padding: 0 10px 0 10px;\r\n    margin: 20px 0 0 0;\r\n  }\r\n\r\n  #container {\r\n    margin: 10px;\r\n    border: 1px solid #D0D0D0;\r\n    box-shadow: 0 0 8px #D0D0D0;\r\n  }\r\n  <\/style>\r\n<\/head>\r\n<body>\r\n\r\n
\r\n  
Welcome to CodeIgniter!<\/h1>\r\n\r\n  
\r\n  
\" enctype=\"multipart\/form-data\" method=\"POST\" role=\"form\">\r\n    Form title<\/legend>\r\n  \r\n  \r\n  \r\n    \r\n  \r\n