1. 安裝PHPExcel:
composer require phpoffice/phpexcel
2. 加載PHPExcel類:
require_once 'vendor/autoload.php';
use PHPExcel;
3. 創建PHPExcel對象:
$excel = new PHPExcel();
4. 讀取excel文件:
$excelReader = PHPExcel_IOFactory::createReaderForFile($filePath);
5. 讀取excel文件中的數據:
$excelObj = $excelReader->load($filePath);
$sheet = $excelObj->getSheet(0);
$data = $sheet->toArray();