在气轻Python73介绍过填充样式背景设置，一般来说填充背景容易想到用bgColor。但用bgColor设置时有个问题，就是当样式设置为'solid&#​39;时，背景颜色设置失效，始终为黑色。用fgColor效果正常了。

原始Excel文件内容：

from openpyxl import load_workbook

from openpyxl.styles import *

import webbrowser

def qipy93():

    fileName = "F:/Data/Image/Data.xlsx&#​34;

    fileName1 = "F:/Data/Image/Data1.xlsx&#​34;

    wb = load_workbook(fileName)

    ws = wb['Sheet1&#​39;]

    rowsMax = ws.max_row

    patternType = ['solid&#​39;,'darkHorizontal&#​39;,'lightDown&#​39;]

    fgColor = ['FF00B050&#​39;,'00FF00&#​39;,'0000FF&#​39;]

    for i in range(rowsMax):

        ws.cell(i + 1, 1).fill = PatternFill(patternType=patternType[i],

                                             fgColor = fgColor[i])

    wb.save(fileName1)

    webbrowser.open(fileName1)

    return

执行结果