- 引入类库
composer require phpoffice/phpspreadsheet
- 使用类库读取
public function excelRead() {
$inputFileType = 'Xls';
$inputFileName = storage_path() . DIRECTORY_SEPARATOR .'123.xls';
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);
$worksheetData = $reader->listWorksheetInfo($inputFileName);
$sheet = $spreadsheet->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$dataInfo = $sheet->toArray();
$cellValue = $sheet->getCell("A1")->getValue();