- 第一步在一个空文件夹里创建一个 php 文件
- 使用 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);
?>