2-2 套用樣板

1. 好處是不用全部都用程式來寫，可以自己設定好各種花俏的格式，程式只負責把值填上

   <?php
   
   require 'vendor/autoload.php';
   
   $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('test.xlsx');
   
   $worksheet = $spreadsheet->getActiveSheet();
   
   $worksheet->getCell('A1')->setValue('套用樣板測試');
   
   header('Content-Type: application/vnd.ms-excel');
   header('Content-Disposition: attachment;filename="套用樣板測試.xls"');
   header('Cache-Control: max-age=0');
   
   $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xls');
   $writer->save('php://output');

   Copy

    

2. 簡單的樣板：text.xlsx