Guest User

Untitled

a guest
Jul 1st, 2020
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. for sheet in book.sheets():
  2. for rowidx in range(sheet.nrows):
  3. row = sheet.row(rowidx)
  4. for colidx, cell in enumerate(row):
  5. if cell.value == "a":
  6. print(sheet.name)
  7. print(colidx + 1, "O")
  8. print(rowidx + 1)
Advertisement
Add Comment
Please, Sign In to add comment