使用xlsxwriter和pandas创建重叠的边界颜色

import pandas as pd
import xlsxwriter

data = {'Column1': [1, 2, 3, 4, 5],
        'Column2': [6, 7, 8, 9, 10],
        'Column3': [11, 12, 13, 14, 15]}
df = pd.DataFrame(data)

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

border_format = workbook.add_format({'border': 1, 'border_color': 'red'})

df.to_excel(worksheet, startrow=1, startcol=1, header=False, index=False)
worksheet.conditional_format('B2:D6', {'type': 'no_errors', 'format': border_format})

workbook.close()