Friday 6 April 2018

Source Code of How to Import Excel File in Codeigniter

By click on below link you can download complete source code file of How to Import Excel File in Codeigniter. Here you can find complete source code file with Codeigniter framework with PHPExcel library loaded. So you have to just make customer table and make database connection. After making of database connection you have to change base_url() of codegniter application. And lastly you have to go to browser and write base url slash excel import controller then you have see file tag and import button on web page. So you can select excel sheet and start importing excel sheet data into mysql database.


  1. On downloading the source code then, creating the customer table and making database connection, It doesn't seem to work yet.

    I get this error:

    An uncaught Exception was encountered

    Type: Error

    Message: Call to undefined method Main_model::fetch_data()

    Filename: C:\xampp\htdocs\ExcelToMySQL\application\controllers\main.php

    Line Number: 9


    File: C:\xampp\htdocs\ExcelToMySQL\index.php
    Line: 315
    Function: require_once

    1. change default controller in route to excel_import
      then change the config in base url like your folder name
      try it.

    2. go to Route File and then change $route['default_controller'] = 'excel_import' ;

  2. You can simply add to drive, after login into gmail you will get that at the top right corner.

  3. i can't download. pls help me