使用openpyxl更改excel列格式类型

import openpyxl

workbook = openpyxl.load_workbook('example.xlsx')

worksheet = workbook['Sheet1']

column_letter = 'A'  # 列的字母标识
column_number = openpyxl.utils.column_index_from_string(column_letter)  # 列的数字标识

for cell in worksheet[column_letter]:
    cell.number_format = '0.00'  # 设置列的格式类型，例如设置为保留两位小数

# 或者可以直接使用列的数字标识
for cell in worksheet.columns[column_number - 1]:
    cell.number_format = '0.00'

workbook.save('example_modified.xlsx')