Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. import xlwings as xl
  2. import xlwings.constants
  3.  
  4. s = xl.Book('doc.xlsx').sheets[0]
  5. RR2 = s.api.Cells.Find(What="*",
  6. After=s.api.Cells(1, 1),
  7. LookAt=xlwings.constants.LookAt.xlPart,
  8. LookIn=xlwings.constants.FindLookIn.xlFormulas,
  9. SearchOrder=xlwings.constants.SearchOrder.xlByRows,
  10. SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
  11. MatchCase=False)
  12.  
  13. RR = s.api.Cells.Find(What="*",
  14. After=s.api.Cells(1, 1),
  15. LookAt=xlwings.constants.LookAt.xlPart,
  16. LookIn=xlwings.constants.FindLookIn.xlFormulas,
  17. SearchOrder=xlwings.constants.SearchOrder.xlByColumns,
  18. SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
  19. MatchCase=False)
  20.  
  21. print((RR2.Row, RR.Column))
  22. pass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement