excel - conditional formatting using xlwt python -


is there way conditional formatting using xlwt? because of code using xlwt.

like this. of code

import xlwt  ....  filename in glob.glob(opensoundingfile):     wb = xlwt.workbook(encoding="latin1")      sheet = wb.add_sheet('input')     sheet2 = wb.add_sheet('transfer')      newname = filename     spamreader = csv.reader(open(filename, 'rb'), delimiter=';',quotechar='"')     rowx, row in enumerate(spamreader):         colx, value in enumerate(row):             sheet.write(rowx, colx, value)         sheet.col(0).width = 5555     sheet.col(1).width = 11110     sheet.col(2).width = 5555     sheet.col(3).width = 3333 .... 

and want input code. thing not working because need xlsxwriter

sheet2.conditional_format('g28:g528:', {'type': 'cell','criteria': '>','value': 100,'format': yellow}) 

if more 100 cell color become yellow. reply


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -