In this post, I would like to show using of PhpSpreadsheet library within your CodeIgniter 3 project. PhpSpreadsheet is a pure PHP library for reading and writing spreadsheet files.
Here is my another post, you might be interested in – How to use PHPExcel with CodeIgniter?
Here are the steps to generate Excel in the CodeIgniter 3 application with PhpSpreadsheet:
Step 1: Download and install CodeIgniter.
Step 2: Run the below composer command to download
phpspreadsheet the library from your project folder. It will create a new folder called “vendor” and it will download
phpoffice/phpspreadsheet library into it.
Here is my the directory structure after installing phpoffice/phpspreadsheet
Step 3: Open
application/config/config.php file and set your vendor directory path
Step 4: Use
phpspreadsheet library inside in your controller, here is the sample:
For more information, here is the official documentation page of – phpspreadsheet documentation
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.