1、先導入openpyxl庫，如沒有先用pip安裝(pip install openpyxl)

import openpyxl

2.打開表格進行操作

excel_file = "文件名.xlsx"
open_work_book = openpyxl.load_workbook(excel_file)
sheet = open_work_book.active

3、對表格操作后進行保存

sheet.cell(row=row[0].row, column=4, value=json.dumps(rule, ensure_ascii=False))
open_work_book.save(excel_file)