How To Show Data With Conditional Formating Data Bars Using xlwings?

Method

rng=sht.Range(‘A1:A15’)

rng.FormatConditions.Delete()

rng.FormatConditions.AddDatabar()

Sample Code

#Conditional Formatting - Data Bars

import xlwings as xw    #Import xlwings
import os    #Import os

root = os.getcwd()    #Get current path
#Create Excel application window, visible, no workbook added
app=xw.App(visible=True, add_book=False)
#Open data file, writable
bk=app.books.open(fullname=root+r'\cf.xlsx',read_only=False)
#Get data worksheet
sht=bk.api.Sheets(1) 

rng=sht.Range('A1:A15')
rng.FormatConditions.Delete()

rng.FormatConditions.AddDatabar()

#bk.save()
#bk.close()
#app.kill()