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 - Unable to make sub reports with Jasper -

sql - The object name contains more than the maximum number of prefixes. The maximum is 2 -

scala - play framework: Modules were resolved with conflicting cross-version suffixes -