Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlwings as xl
- import xlwings.constants
- s = xl.Book('doc.xlsx').sheets[0]
- RR2 = s.api.Cells.Find(What="*",
- After=s.api.Cells(1, 1),
- LookAt=xlwings.constants.LookAt.xlPart,
- LookIn=xlwings.constants.FindLookIn.xlFormulas,
- SearchOrder=xlwings.constants.SearchOrder.xlByRows,
- SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
- MatchCase=False)
- RR = s.api.Cells.Find(What="*",
- After=s.api.Cells(1, 1),
- LookAt=xlwings.constants.LookAt.xlPart,
- LookIn=xlwings.constants.FindLookIn.xlFormulas,
- SearchOrder=xlwings.constants.SearchOrder.xlByColumns,
- SearchDirection=xlwings.constants.SearchDirection.xlPrevious,
- MatchCase=False)
- print((RR2.Row, RR.Column))
- pass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement