After successfully create a database, you can use the below sql query for creating a table in your database. In this step, we need to create database name demo, so let’s open your phpmyadmin and create the database with the name demo. Require_once APPPATH.'/third_party/PHPExcel.php' If (!defined('BASEPATH')) exit('No direct script access allowed') Now we need to create Excel.php file into application/library, So go to application/library and create one file name Excel.php and put the below code here. After extract this library move to PHPExcel folder like application/third_party/PHPExcel and also move PHPExcel.php file to application/third_party/PHPExcel.php. Next, we need to download phpExcel library from this link, and extract into application/third_party folder.

Set Base URL like this $config = ' Download phpExcel Libraryĭownload this excel library here : click here Next we will set the some basic configuration on config.php file, so let’s go to application/config/config.php and open this file on text editor. And change the download folder name “demo” Basic Configurations In this step we will download the latest version of Codeigniter, Go to this link Download Codeigniter download the fresh setup of codeigniter and unzip the setup in your local system xampp/htdocs/. Conclusion Download Codeigniter Project.Excel is the best technique to Export data in a file and you can easily export data to Excel or CSV using Codeigniter excel library. In this codeigniter excel,csv export tutorial, we will would love to share with you how to Export data into Excel or CSV in CodeIgniter.

Export calibre library to excel