def color_execl(file_name, col, x):
print(file_name, '#开始着色#')
styleredBkg = xlwt.easyxf('pattern: pattern solid, fore_colour red;') # 红色
rb = xlrd.open_workbook(file_name)
ro = rb.sheets()[x]
wb = copy(rb)
ws = wb.get_sheet(x)
for i in range(ro.nrows):
result = str(ro.cell(i, col).value)
if 'Dele' in result:
ws.write(i, col, ro.cell(i, col).value, styleredBkg)
wb.save(file_name)
print(file_name, ro, '#着色完成#')
color_execl('MongoData.xls', 6, 0)
color_execl('MongoData.xls', 5, 1)
有可能最后一次将第一次覆盖了。