How to generate an Excel using php
Last modified: July 24, 2021Step 1
User composer to install phpoffice/phpspreadsheet
composer require phpoffice/phpspreadsheet
Step 2
<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');
$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx'); //save it to the server
//download the excel file
$writer = new Xlsx($spreadsheet);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="'. urlencode('hello_world.xlsx').'"');
$writer->save('php://output');
?>
