PHPExcel is a pure PHP library for reading and writing spreadsheet files and CodeIgniter is one of the well known PHP MVC Framework. In this tutorial, I am gonna show you how to Integrate PHPEXcel library in CodeIgniter with simple steps.
Here is my another post, you might be interested in – How to generate Excel using PhpSpreadsheet in CodeIgniter?
Setp 1: Download and setup CodeIgniter.(download it here: https://ellislab.com/codeigniter)
Setp 2: Download PHPExcel.(download it here: http://phpexcel.codeplex.com/)
Setp 3: Unzip or extract the downloaded PHPExcel lib files and copy Class directory inside files to
setp 4: Now create one file called
application/library folder [application/library/Excel.php]. Then include PHPExcel Class to it. see how I did it below
That’s it now you can use PHPEXcel methods inside your CodeIgniter application.But you should load it before using it methods(Ex: $this->load->library(‘excel’);)
How to read excel file
How to Create excel file on the file
How to Generate Excel file with Database table data
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.