import os from openpyxl import load_workbook if not os.path.exists('我的电子表格'): os.makedirs('我的电子表格') filename = input("请先将文件放到我的电子表格文件夹中,并输入你要编辑的电子表格名字:") wb = load_workbook(f"./我的电子表格/{filename}.xlsx") ws = wb.active while True: text = input("请输入你要查找的内容:") new_text = input("请输入你要替换的内容:") def find_text_in_cell(ws,text): found_cells = [] for row in ws.iter_rows(): for cell in row: if text in str(cell.value): found_cells.append(cell) return found_cells cells_to_change = find_text_in_cell(ws,text) print(cells_to_change) def replace_text_in_cell(cells,text,newtext): i=0 for cell in cells: i += 1 cell.value = str(cell.value).replace(text,newtext) print(f"第{i}个{text}已替换成{new_text}") replace_text_in_cell(cells_to_change,text,new_text) wb.save('./我的电子表格/处理后的数据.xlsx')