Python Xlsxwriter格式化表中的特定列

import xlsxwriter

workbook = xlsxwriter.Workbook('output.xlsx')
worksheet = workbook.add_worksheet()

format1 = workbook.add_format({'bold': True, 'bg_color': 'yellow'})

worksheet.write('A1', '列1', format1)
worksheet.write('B1', '列2')
worksheet.write('C1', '列3')

data = [['数据1', '数据2', '数据3'],
        ['数据4', '数据5', '数据6']]
        
row = 1
col = 0

for item in data:
    worksheet.write(row, col, item[0])
    worksheet.write(row, col + 1, item[1])
    worksheet.write(row, col + 2, item[2])
    row += 1

workbook.close()