如何使用Python在Excel中替换一个单词？

Pip install openpyxl

openpyxl.load_workbook(‘your_excel_file’)

import openpyxl# Load the Excel spreadsheetworkbook = openpyxl.load_workbook('example.xlsx')# Select the active worksheetworksheet = workbook.activePrint("Workbook loaded")

Workbook loaded

import openpyxl# Load the Excel spreadsheetworkbook = openpyxl.load_workbook('testing.xlsx')# Select the active worksheetworksheet = workbook.active# Replace the word 'old_word' with 'new_word'for row in worksheet.iter_rows():   for cell in row:      if cell.value == 'old_word':         print("Word found")         cell.value = 'new_word'         print("word replaced")                  else:         # Save the changesworkbook.save('testing.xlsx')

import openpyxl# Load the Excel spreadsheetworkbook = openpyxl.load_workbook('example.xlsx')# Select the active worksheetworksheet = workbook.active# Define the words to be replaced and their replacementsreplacements = {   'old_word_1': 'new_word_1',   'old_word_2': 'new_word_2',   'old_word_3': 'new_word_3'}# Replace the wordsfor row in worksheet.iter_rows():   for cell in row:      if cell.value in replacements:         print("Word found")         cell.value = replacements[cell.value]         print("word replaced")              else:         print("word not found")# Save the changesworkbook.save('example.xlsx')