如何批量修改数字？

是经常还是一次，一次的话就自己修改完了呗，几十个将就下，经常的话就要去找人写一个脚本工具

import os
from openpyxl import load_workbook
def modify_excel(file_path):
wb = load_workbook(file_path)
for sheet_name in wb.sheetnames:
sheet = wb[sheet_name]
for row in sheet.iter_rows():
for cell in row:
if isinstance(cell.value, str) and "speed=" in cell.value:
index = cell.value.find("speed=")
num_str = cell.value[index + 6:]
try:
num = int(num_str)
new_value = cell.value[:index + 6] + str(num - 1)
cell.value = new_value
except ValueError:
pass
wb.save(file_path)
folder_path = "G:\\"
for file_name in os.listdir(folder_path):
if file_name.endswith(".xlsx"):
file_path = os.path.join(folder_path, file_name)
modify_excel(file_path)
print("处理完成！")
看得懂你就用吧，不收费