如何使用 PHP 访问 Microsoft Excel 表格？

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\IOFactory;

// 读取 Excel 文件

$spreadsheet = IOFactory::load('path/to/file.xlsx');

// 获取活动工作表

$worksheet = $spreadsheet->getActiveSheet();

// 获取单元格值

$cellValue = $worksheet->getCell('A1')->getValue();

// 遍历所有单元格

foreach ($worksheet->getRowIterator() as $row) {

    foreach ($row->getCellIterator() as $cell) {

        echo $cell->getValue() . "\t";

    }

    echo "\n";

}

use PhpOffice\PhpSpreadsheet\IOFactory;

// 创建新工作簿

$spreadsheet = new PhpSpreadsheet();

// 设置活动工作表

$worksheet = $spreadsheet->getActiveSheet();

// 设置单元格值

$worksheet->setCellValue('A1', 'Hello World!');

// 保存文件

IOFactory::save($spreadsheet, 'path/to/newfile.xlsx');

use PhpOffice\PhpSpreadsheet\IOFactory;

// 创建新工作簿

$spreadsheet = new PhpSpreadsheet();

// 设置工作表标题