Use the `PatternFill` class to create a pattern fill object.<\/p>\n
from openpyxl.styles.fills import PatternFill<\/p>\n
PatternFill(patternType=None,fgColor=<openpyxl.styles.colors.Color object><\/p>\n
Parameters: rgb=’00000000′, indexed=None, auto=None, theme=None, tint=0.0, type=’rgb’, bgColor=<openpyxl. styles.colors.Color object><\/p>\n
Parameters: rgb=’00000000′, indexed=None, auto=None, theme=None, tint=0.0, type=’rgb’, fill_type=None, start_color=None, end_color= None)<\/p>\n
Where<\/span>\uff1a<\/span><\/p>\n patternType<\/span>\u3001<\/span>fill_type<\/span>\u2014<\/span>The pattern fill type, its value must be one of the following: <\/span>“darkDown”<\/span>\u3001<\/span>“gray0625”<\/span>\u3001<\/span>“mediumGray”<\/span>\u3001<\/span>“darkHorizontal”<\/span>\u3001<\/span>“lightVertical”<\/span>\u3001<\/span>“darkGrid”<\/span>\u3001<\/span>“lightGray”<\/span>\u3001<\/span>“darkTrellis”<\/span>\u3001<\/span>“darkVertical”<\/span>\u3001<\/span>“lightGrid”<\/span>\u3001<\/span>“solid”<\/span>\u3001<\/span>“lightDown”<\/span>\u3001<\/span>“lightUp”<\/span>\u3001<\/span>“darkUp”<\/span>\u3001<\/span>“darkGray”<\/span>\u3001<\/span>“lightTrellis”<\/span>\u3001<\/span>“lightHorizontal”<\/span>\u3001<\/span>“gray125”<\/span>\u3001<\/span>None<\/span>\u3002<\/span><\/p>\n fgColor<\/span>\u3001<\/span>start_color<\/span>\u2014<\/span>Foreground color, the value of fgColor must be a Color object.<\/span><\/p>\n bgColor<\/span>\u3001<\/span>end_color<\/span>\u2014<\/span>Background color, the value of bgColor must be a Color object.<\/span><\/p>\n \u00a0<\/p>\n When **fill_type** is set to None, no fill will be applied.<\/p>\n When **fill_type** is set to ‘Solid’, it will be a solid color fill.<\/p>\n OpenPyXL<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-openpyxl-cell-range"],"_links":{"self":[{"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":2,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":251,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/posts\/25\/revisions\/251"}],"wp:attachment":[{"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/openpyxl.com\/blog\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Sample Code<\/h2>\n\n\n
#Cell Style: Pattern Fill\n\n#Import load_workbook function\nfrom openpyxl import Workbook\n\n#Create a new workbook\nwb=Workbook()\n#Get the active worksheet\nws=wb.active\n\n#Import PatternFill class\nfrom openpyxl.styles import PatternFill\nfrom openpyxl.styles.colors import Color\n\n#Pattern fill\nws['B2'].fill=PatternFill(fill_type=None, \\\n start_color='FFFF00', end_color='000000')\nws['C2'].fill=PatternFill(fill_type='solid', \\\n start_color='00FF00')\nws['E2'].fill=PatternFill(fill_type='lightGrid', \\\n start_color='FFFF00', end_color='000000')\nfill=PatternFill(fill_type='lightTrellis', \\\n fgColor=Color(rgb='00FF00'), bgColor=Color(rgb='0000FF'))\nws.column_dimensions['B'].fill=fill\nfill=PatternFill(fill_type='lightGray', \\\n fgColor=Color(rgb='FFFF00'), bgColor=Color(rgb='0000FF'))\nws.row_dimensions[4].fill = fill\n\nwb.save('test.xlsx')\nwb.close()<\/code><\/pre>\n\n\n\n![\"Set](\"https:\/\/openpyxl.com\/blog\/wp-content\/uploads\/2026\/01\/11.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"