01.function phpexcel()
02. {
03. echo 'PHPExcel';
04. $spreadsheet = new Spreadsheet();
05. $sheet = $spreadsheet->getActiveSheet();
06.
07.
08. $sheet->setCellValue('A1', 'Hello World!!');
09. $sheet->setCellValue('A2', 'ทดสอบข้อความภาษาไทย!!');
10.
11. $writer = new Xlsx($spreadsheet);
12.
13.
14. $rand_no = rand(000000, 999999);
15. $filename = 'ExcelNo-' . date("dmY_His") . '.xlsx';
16.
17. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
18. header('Content-Disposition: attachment;filename="' . $filename . '"');
19. header('Cache-Control: max-age=0');
20.
22. }
