You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
31 lines
1021 B
31 lines
1021 B
<?php
|
|
// Load Composer's autoloader
|
|
require_once '/common/composer/vendor/autoload.php';
|
|
|
|
// Import PhpSpreadsheet classes into the global namespace
|
|
// These must be at the top of your script, not inside a function
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Xls;
|
|
//use PhpOffice\PhpSpreadsheet\Reader\Xls;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
|
|
|
|
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
|
|
$spreadsheet = $reader->load("reimburse-sample.xls");
|
|
echo "success";
|
|
//var_dump($spreadsheet);
|
|
//json_encode(var_dump($spreadsheet));
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
$sheet->setCellValue('H3','M1111230707');
|
|
$sheet->setCellValue('H6','資訊部');
|
|
$writer = new Xls($spreadsheet);
|
|
$writer->save('0720helloworld3.xls');
|
|
|
|
// $spreadsheet = new Spreadsheet();
|
|
// $sheet = $spreadsheet->getActiveSheet();
|
|
// $sheet->setCellValue('A1', 'Hello World !');
|
|
|
|
// $writer = new Xlsx($spreadsheet);
|
|
// $writer->save('hello world.xlsx');
|
|
|
|
|
|
echo "success";
|