[PhpSpreadsheet(PHPExcel)的使用 —— 生成/读取excel - 腾讯云开发者社区-腾讯云 (tencent.com)](https://cloud.tencent.com/developer/article/2010686) ``` #read.php <?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\IOFactory; $inputFileName = __DIR__ . '/x1.xlsx'; //方法1.1, 1.2, 2都可以 //方法1：自动识别文件类型 //方法1.1 $spreadsheet = IOFactory::load($inputFileName);//自动识别文件类型 //方法1.2 //$spreadsheet= IOFactory::createReaderForFile($inputFileName)->setReadDataOnly(true)->load($inputFileName); //方法2：指定文件类型 //$spreadsheet = IOFactory::createReader("Xlsx")->load($inputFileName); $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true); var_dump($sheetData); ```