填充单元格使用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")