Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. #Color 01
  2. rownumber = 1
  3.  
  4. for row in sheet.iter_rows(min_row=2, max_row= sheet.max_row, min_col=1, max_col=4, values_only=True):
  5. rownumber += 1
  6. for cell in row:
  7. if cell is not None and ('Item1','Item2') in str(cell):
  8. for row2 in sheet.iter_rows (min_row=rownumber, max_row=rownumber, min_col=1, max_col=12):
  9. for cell1 in row2:
  10. cell1.fill = color1_fill
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement