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.
Similar Posts
CodeIgniter 4 – Export data to excel in CodeIgniter using PhpSpreadsheet
How to use PHPExcel with CodeIgniter?
How to generate excel from the array using PHPExcel
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.
|
1 |
$ composer require phpoffice/phpspreadsheet |
Here is my the directory structure after installing phpoffice/phpspreadsheet
Step 3: Open application/config/config.php file and set your vendor directory path
|
1 |
$config['composer_autoload'] = 'vendor/autoload.php'; |
Step 4: Use phpspreadsheet library inside in your controller, here is the sample:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
<?php defined('BASEPATH') OR exit('No direct script access allowed'); use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; class Welcome extends CI_Controller { public function index() { $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $filename = 'name-of-the-generated-file.xlsx'; $writer->save($filename); // will create and save the file in the root of the project } public function download() { $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $filename = 'name-of-the-generated-file'; header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'. $filename .'.xlsx"'); header('Cache-Control: max-age=0'); $writer->save('php://output'); // download file } } |
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.
can you make tutorial about import ?
Sure I will do in this week
Hi Arjun,
with your code I have problems when I try to open the file with Excel through the ‘Open with / Save’ menu.
I had to substitute the line:
header(‘Content-Type: application/vnd.ms-excel’);
with:
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’);
i can’t download it.even i has been subscribe to you
Sorry I about it I will check and fix.
I GET THIS ERROR IN THE FILE DOWNLOADED
An uncaught Exception was encountered
Type: Error
Message: Class ‘PhpOfficePhpSpreadsheetSpreadsheet’ not found
Filename: C:laragonwwwsitprogbdapplicationcontrollersWelcome.php
Line Number: 11
Backtrace:
File: C:laragonwwwsitprogbd7d91e3-7a16-40e5-852c-a29107d38299index.php
Line: 315
Function: require_once
Thanks, It helps a lot
Hi Arjun, I tried to follow your tutorial and I’m getting an response error. I created a thread on stackoverflow about it, but no success:
https://stackoverflow.com/questions/54671184/getting-err-invalid-response-with-codeigniter-and-phpspreadsheet?noredirect=1#comment96132334_54671184
Can you help me?
Good article thanks !!
super
hii how can i use this spreadsheet
Didn’t understand your question. Can you elaborate?
actually m working in hmvc in codeigniter where i can make sub modules so how can i use
CI version?
Are you using composer?
[…] Here is another post, you might be interested in – How to generate Excel using PhpSpreadsheet in CodeIgniter? […]