使用 PHP 对 Excel 单元格数据进行处理

1. 第一步在一个空文件夹里创建一个 php 文件
2. 使用 composer 加载 Excel 包

composer require phpoffice/phpspreadsheet
phpspreadsheet 官网
https://phpspreadsheet.readthedocs.io

具体代码在下面

<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;

$file = "./file.xlsx";
$spreadsheet = IOFactory::load($file);
// 获取第一个工作表
$worksheet = $spreadsheet->getActiveSheet();
// 获取最大行数和列数
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
// 循环读取每个单元格的值
for ($row = 2; $row <= $highestRow; $row++) {	// 行
    for ($col = 'A'; $col <= $highestColumn; $col++) { // 列
        $cellValue = $worksheet->getCell($col . $row)->getValue(); // 获取值
        $result = strip_tags(html_entity_decode($cellValue)); // 处理值
        $worksheet->getCell($col . $row)->setValue($result); // 重新赋值
    }
}
// 保存修改后的Excel文件
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save($file);
?>