Importing data from an Excel file into a CodeIgniter application is a common requirement for applications that need to process bulk records. Instead of entering records manually, users can upload an Excel file and import multiple rows of data into the application.<\/p>\n\n\n\n
In this guide, we will explain how to implement Excel file importing in CodeIgniter using PHPExcel. The example demonstrates how to load an Excel file, read the spreadsheet data, and access individual column values.<\/p>\n\n\n\n
Before proceeding, make sure you have:<\/p>\n\n\n\n
Step 1: Download the PHPExcel Library<\/p>\n\n\n\n
Download the PHPExcel library from its GitHub repository or the official PHPExcel website.<\/p>\n\n\n\n
You can download the PHPExcel library from the following repository:<\/p>\n\n\n\n
After downloading, extract the PHPExcel archive on your local system.<\/p>\n\n\n\n
Step 2: Copy PHPExcel to CodeIgniter<\/p>\n\n\n\n
After extracting the PHPExcel library, you will find directories such as:<\/p>\n\n\n\n
Classes\nDocumentation\nExamples<\/pre>\n\n\n\nNavigate to the
Classes<\/code> directory and copy the following into your CodeIgniter application’sapplication\/third_party\/<\/code> directory:<\/p>\n\n\n\nStep 3: Create the Excel Import Library<\/p>\n\n\n\n
Navigate to:<\/p>\n\n\n\n
application\/libraries\/<\/p>\n\n\n\n
Create a new file named:<\/p>\n\n\n\n
ExcelImport_lib.php<\/p>\n\n\n\n
Add the following code to the file:<\/p>\n\n\n\n
<?php\n if ( ! defined('BASEPATH')) exit('No direct script access allowed'); \n ini_set('error_reporting', E_STRICT); \n require_once APPPATH.\"\/third_party\/PHPExcel.php\"; \n class ExcelImport_lib extends PHPExcel \n { public function __construct() \n \t{ parent::__construct(); } \n } ?><\/pre>\n\n\n\nStep4:
Navigate to application\/controllers and create new file name as ImportExcel.php,place following code here<\/p>\n\n\n\n<?php\nif ( ! defined('BASEPATH')) exit('No direct script access allowed'); \n\/**\n * summary\n *\/\nclass ImportExcel extends CI_Controller\n{\n public function index()\n {\n \t$this->load->view('excelimport');\t\n }\n public function Import($value='')\n {\n $this->load->library('ExcelImport_lib');\n \t\t\t\n try {\n \/\/\/ it will be your file name that you are posting with a form or can pass static name $_FILES[\"file\"][\"name\"];\n \t\/\/ $objPHPExcel = PHPExcel_IOFactory::load('uploads\/'.$_FILES[\"file\"][\"name\"]);\n \t$objPHPExcel = PHPExcel_IOFactory::load('uploads\/'.'yourTableName.xls');\n\n }\n catch(Exception $e)\n {\n $this->resp->success = FALSE;\n $this->resp->msg = 'Error Uploading file';\n echo json_encode($this->resp);\n exit;\n }\n\n $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);\n print_r($allDataInSheet);\n foreach($allDataInSheet as $import)\n {\n echo $import['A']; \/\/\/ will return values of Col A\n echo $import['B']; \/\/\/ will return values of Col B\n echo $import['C']; \/\/\/ will return values of Col C\n echo $import['D']; \/\/\/ will return values of Col D\n\n }\n }\n}\n\n?><\/pre>\n\n\n\nStep5:
Navigate to application\/view and create new file name as excelimport.php,place following code here<\/p>\n\n\n\n<?php
defined('BASEPATH') OR exit('No direct script access allowed');
?><!DOCTYPE html>
<html lang=\"en\">
<head>
<meta charset=\"utf-8\">
<title>Welcome to CodeIgniter<\/title>
<style type=\"text\/css\">
::selection { background-color: #E13300; color: white; }
::-moz-selection { background-color: #E13300; color: white; }
body {
background-color: #fff;
margin: 40px;
font: 13px\/20px normal Helvetica, Arial, sans-serif;
color: #4F5155;
}
a {
color: #003399;
background-color: transparent;
font-weight: normal;
}
h1 {
color: #444;
background-color: transparent;
border-bottom: 1px solid #D0D0D0;
font-size: 19px;
font-weight: normal;
margin: 0 0 14px 0;
padding: 14px 15px 10px 15px;
}
code {
font-family: Consolas, Monaco, Courier New, Courier, monospace;
font-size: 12px;
background-color: #f9f9f9;
border: 1px solid #D0D0D0;
color: #002166;
display: block;
margin: 14px 0 14px 0;
padding: 12px 10px 12px 10px;
}
#body {
margin: 0 15px 0 15px;
}
p.footer {
text-align: right;
font-size: 11px;
border-top: 1px solid #D0D0D0;
line-height: 32px;
padding: 0 10px 0 10px;
margin: 20px 0 0 0;
}
#container {
margin: 10px;
border: 1px solid #D0D0D0;
box-shadow: 0 0 8px #D0D0D0;
}
<\/style>
<\/head>
<body>
Welcome to CodeIgniter!\" enctype=\"multipart\/form-data\" method=\"POST\" role=\"form\">
Form title
Click to Read
<\/body>
<\/html><\/pre>\n\n\n\nConclusion<\/h3>\n\n\n\n
Excel importing makes it much easier to handle bulk data in a CodeIgniter application. Using PHPExcel, we can load an Excel file, convert the spreadsheet into an array, read individual columns, and insert the data into a database.<\/p>\n\n\n\n
The basic workflow is:<\/p>\n\n\n\n
Upload Excel File\n \u2193\nRead Excel File\n \u2193\nConvert Spreadsheet to Array\n \u2193\nValidate Data\n \u2193\nInsert\/Update Database\n \u2193\nDisplay Import Result<\/pre>\n\n\n\nFAQs<\/h4>\n\n\n\n
1. Can I import both XLS and XLSX files?<\/h5>\n\n\n\n
Yes. PHPExcel can work with both older
.xls<\/code> files and.xlsx<\/code> files, provided the appropriate reader is available.<\/p>\n\n\n\n2. Can I upload the Excel file instead of specifying a fixed filename?<\/h5>\n\n\n\n
Yes. You can use PHP’s
$_FILES<\/code> to process the file uploaded through an HTML form.<\/p>\n\n\n\n3. Where should I place PHPExcel in CodeIgniter?<\/h5>\n\n\n\n
For the approach shown in this tutorial, place the required PHPExcel files inside:<\/p>\n\n\n\n
application\/third_party\/<\/pre>\n\n\n\n4. How can I access Excel columns?<\/h5>\n\n\n\n
PHPExcel returns columns using Excel-style column names:<\/p>\n\n\n\n
$row['A'];
$row['B'];
$row['C'];
$row['D'];<\/pre>\n\n\n\n5. Can I insert the imported data into MySQL?<\/h5>\n\n\n\n
Yes. After reading and validating each row, you can use CodeIgniter’s database methods such as:<\/p>\n\n\n\n
$this->db->insert('users', $data);<\/pre>\n\n\n\nRelated Article<\/h2>\n\n\n\n
How to add Google ReCAPTCHA in PHP Codeigniter \u2013 Pheonix Solutions<\/a><\/p>\n\n\n\n