How To Create Conditional Formatting Data Bars For Specified Data Using OpenPyXL?

Method

from openpyxl.formatting.rule import DataBarRule

from openpyxl.styles import colors

 

workbook= load_workbook(filename=’wb2.xlsx’)

sheet= workbook.active

rule= DataBarRule(start_type=’percentile’, \

                    start_value=10, \

                    end_type=’percentile’, \

                    end_value=90, \

                    color=’0000FF’)

sheet.conditional_formatting.add(‘B2:B11’, rule)

Sample Code

#Data Bars

from openpyxl import load_workbook
from openpyxl.formatting.rule import DataBarRule
from openpyxl.styles import colors

#Load Data
workbook= load_workbook(filename='wb2.xlsx')
sheet= workbook.active

#Draw Data Bars
#Plot with Percentage Data
rule= DataBarRule(start_type='percentile', \
                    start_value=10, \
                    end_type='percentile', \
                    end_value=90, \
                    color='0000FF')
sheet.conditional_formatting.add('B2:B11', rule)
workbook.save('test.xlsx')

workbook= load_workbook(filename='wb2.xlsx')
sheet= workbook.active

#Plot with Actual Data
rule= DataBarRule(start_type='num', \
                    start_value=150000, \
                    end_type='num', \
                    end_value=1300000, \
                    color='FF0000')
sheet.conditional_formatting.add('A2:A11', rule)
workbook.save('test2.xlsx')