将openpyxl格式从文本设置为数字

from openpyxl import load_workbook

# 打开Excel文件
workbook = load_workbook('example.xlsx')

# 选择工作表
worksheet = workbook['Sheet1']

# 遍历需要设置为数字格式的单元格
for row in worksheet.iter_rows(min_row=2, min_col=2, max_row=worksheet.max_row, max_col=worksheet.max_column):
    for cell in row:
        # 将文本格式设置为数字格式
        cell.number_format = '0.00'

# 保存修改后的Excel文件
workbook.save('example.xlsx')