In this CodeIgniter 4 tutorial, you will learn, exporting data to excel using the PhpSpreadsheet library.
Install CodeIgniter 4
Let’s create a brand new CodeIgniter 4 project with the composer command.
The preceding command will generate the
ci4-excel folder along with CodeIgniter project files. After creating the project you can run and see the output. Upon successful setup, you should be able to see the below output in the browser without any error. Let’s start the development server with Command Line Tool as shown below.
Now access the application at
Install PHP spreadsheet
phpoffice/phpspreadsheet the library with composer with the below-shown command.
CodeIgniter 4 Database Connection
Rename env file to .env which will be located at project root and update database details and environment details.
Import the below table scheme to create a tasks table in your database.
Now import sample data into the tasks table.
Now let’s create a Model class for the tasks table called
Create your controller file app\Controllers\Excel.php.
Now start your application
Now access your application at
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.