Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- https://phpspreadsheet.readthedocs.io/en/latest/#hello-world
- */
- // require 'vendor/autoload.php';
- // -> tidak perlu karena automatis dari laravel
- // use PhpOffice\PhpSpreadsheet\Spreadsheet;
- // use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- // langsung dijalankan di coding bawah
- // $spreadsheet = new Spreadsheet();
- $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
- $sheet = $spreadsheet->getActiveSheet();
- $sheet->setCellValue('A1', 'Hello World ! This is Laravel Excel');
- // $writer = new Xlsx($spreadsheet);
- $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
- $writer->save('hello.xlsx');
- //menulis
- //dikeluarkan
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment;filename="01simple.xlsx"');
- header('Cache-Control: max-age=0');
- // If you're serving to IE 9, then the following may be needed
- header('Cache-Control: max-age=1');
- // If you're serving to IE over SSL, then the following may be needed
- header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
- header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
- header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
- header('Pragma: public'); // HTTP/1.0
- $file = file_get_contents('hello.xlsx');
- print $file;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement