最近在尝试通过php读取excel以及txt里的数据

php读取excel

用到了PhpOffice\PhpSpreadsheet

读取单元格值

<?php require_once 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; use PhpOffice\PhpSpreadsheet\Reader\IReader; use PhpOffice\PhpSpreadsheet\IOFactory; $inputFileName = 'Chinese_Family_Name（1k）.xlsx'; /** Load $inputFileName to a Spreadsheet Object **/ $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileName); // Get the value from cell A1 echo $cellValue = $spreadsheet->getActiveSheet()->getCell('A3')->getValue(); echo '<br>';