Create Excel Using PHPSpreadsheet in CodeIgniter | Download Excel Format

In this video , you will be able to create excel using phpspreadsheet in codeigniter and also download the created excel in downloadable format.
I have created one button with text download format, I will changing that to an anchor tag.
Pass the href of your controller function.
In controller ,
firstly include vendor/autoload.php file
after that use
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
Spreadsheet - for creating a worksheet in excel
xlsx -for creating excel file
we will be passing worksheet (spreadsheet) to xlsx - this will create a excel file that contain a worksheet.
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet-getActiveSheet();
$sheet- setCellValue('A1', 'Hello World !');
$writer = new Xlsx($spreadsheet);
$writer- save('hello world.xlsx');
For download of excel file, you have to add headers
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="hello_world.xlsx"');
save will save that in a particular folder
For download you need to pass php://output to download in excel
$writer- save("php://output");
In my previous video, I have shown how to install php spreadsheet in codeigniter, if you have not watched it please check it out:
• Installation of PhpSpr...
Documentation:
phpspreadsheet...
Starting hello world:
phpspreadsheet...
Code Link:
github.com/sus...
#codeigniter #knowledgethrusters

[@markeybygeeta4740]

Thanks For creating valuable videos

[@nabilunnajib3505]

Thanks a lot, it's really help me, i'm stuck on that problem for 2 days long or more

[@rockon420ful]

hi I am not able to integrate spread sheet in xampp php8 version - root folder I added vendor folder in vendor folder autoload.php file , add in controller file in top and add name spaces for this line i am getting an error $spreadsheet = new Spreadsheet(); error as - Type: Error Message: Class "Spreadsheet" not found Please let me know ho to fix it

[@AnkitaChitkul]

not getting vendor folder in your code files

[@AlokKejriwal]

How to implement the same Codeigniter 2?