[python][openpyxl]填充单元格

填充单元格使用openpyxl.styles中的PatternFill。

代码如下：

from openpyxl.styles import PatternFill, Font

wb = Workbook()
ws1 = wb.active
ws1.title = 's1'                         #更改sheet的名字
ft = Font(bold=True, color=colors.RED)   # 首行字体加粗
# red    : start_color ='FFFF0000', end_color = 'FFFF0000', fill_type = 'solid'
# yellow : start_color ='FFFF00', end_color = 'FFFF00', fill_type = 'solid'
fill = PatternFill(start_color ='FFFF00', end_color = 'FFFF00', fill_type = 'solid')  #填充黄色
ws1.cell(row = 1, column = 1, value = 10).fill = fill
ws1.cell(row = 1, column = 2, value = 10).Font = ft
ws2 = wb.create_sheet('s2')
ws2['A1'] = 1
ws2['A1'].hyperlink = '#s1!A1'    # 超链接
wb.save("statistic_results.xlsx")