PhpSpreadsheet（php讀取Excel、CSV）的安裝與使用

參考網站
https://www.itread01.com/content/1546366076.html

1.安裝Composer
https://getcomposer.org/doc/00-intro.md#installation-windows
下載後執行，要選擇當前使用的php.exe所在位置
安裝完後重啟php、重啟command

2.安裝
在command前往php.exe所在位置
輸入
composer require phpoffice/phpspreadsheet
執行


3.測試
重啟php
用下面文字建立一個php檔案，放到網頁伺服器底下

<?php
//這行要改成php底下vendor的絕對路徑
require '/vendor/autoload.php';

//寫入範例
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet       = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', '這是第一格');

$writer = new Xlsx($spreadsheet);
$writer->save('aaa.xlsx');

//讀取範例
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
try {
//路徑隨需要更改
    $spreadsheet = $reader->load('./excel/0001.xlsx');
} catch (\PhpOffice\PhpSpreadsheet\Reader\Exception $e) {
    die($e->getMessage());
}

$sheet = $spreadsheet->getActiveSheet();

$res = array();
foreach ($sheet->getRowIterator(1) as $row) {
    $tmp = array();
    foreach ($row->getCellIterator() as $cell) {
        $tmp[] = $cell->getFormattedValue();
    }
    $res[$row->getRowIndex()] = $tmp;
}
echo json_encode($res,JSON_UNESCAPED_UNICODE);
?>