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
Post a Comment