如何使用Python中的xlsxwriter创建"if and“语句来有条件地设置单元格列的格式

pip install xlsxwriter

import xlsxwriter

# 创建一个Excel文件
workbook = xlsxwriter.Workbook('output.xlsx')

# 创建一个工作表
worksheet = workbook.add_worksheet()

# 定义单元格格式
bold_format = workbook.add_format({'bold': True})
highlight_format = workbook.add_format({'bg_color': 'yellow'})

# 数据
data = [
    ['Name', 'Score'],
    ['Alice', 80],
    ['Bob', 90],
    ['Charlie', 70],
]

# 写入数据
for row_num, row_data in enumerate(data):
    for col_num, cell_data in enumerate(row_data):
        # 设置第一行为粗体
        if row_num == 0:
            worksheet.write(row_num, col_num, cell_data, bold_format)
        # 根据条件设置单元格格式
        elif cell_data < 75:
            worksheet.write(row_num, col_num, cell_data, highlight_format)
        else:
            worksheet.write(row_num, col_num, cell_data)

# 关闭Excel文件
workbook.close()