Yii v2 snippet guide II

Comparing #13 with #14

Revision #14 was created by rackycz rackycz on Sep 8, 2020, 7:15:40 PM.

Composer and PhpExcel

Content

[...]
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);

// You can save the file on the server:
// $writer->save('hello _world.xlsx');

// Or you can send the file directly to the browser so user can download it:
[...]
header('Content-Type: application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // This is for XLSX files (they are basically zip files).
header('Content-Disposition: attachment;filename="filename.xlsx"');
$writer->save('hello _world.xlsx'); exit(); ```