python - 如何使用python填充excel中的背景单元格？

Question

我有一个 excel 文件无法填充单元格的背景颜色。下面是代码

 import openpyxl
 import pdb
 from openpyxl import Workbook
 from openpyxl.styles import Color, PatternFill, Font, Border
 from openpyxl.styles import colors
 from openpyxl.cell import Cell
 wb = openpyxl.load_workbook('fancy.xlsx')
 ws = wb.active
 fill = PatternFill(fill_type=None,start_color='FFFFFFFF',end_color='FF000000')
 ws['A2'].fill = fill

标签： pythonexcelopenpyxl