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.readthedocs.io...
Starting hello world:
phpspreadsheet.readthedocs.io...
Code Link:
github.com/sushma-singh-yadav...
#codeigniter #knowledgethrusters
6 май 2021
