xlwings find used range boundaries (last used row and last used column)

findLastUsedRowsAndCols.py

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

Hey!

I found this code while trying to find a way to select the used range of a sheet. I came up with something I thought could be useful to others:

import xlwings as xw

out_wb = xw.Book(r"x:\EPA_MPG\not_matched_comparator.xlsm")

active_sheet = out_wb.sheets.active
used_range_rows = (active_sheet.api.UsedRange.Row, 
	active_sheet.api.UsedRange.Row + active_sheet.api.UsedRange.Rows.Count)
used_range_cols = (active_sheet.api.UsedRange.Column, 
	active_sheet.api.UsedRange.Column + active_sheet.api.UsedRange.Columns.Count)
used_range = xw.Range(*zip(used_range_rows, used_range_cols))
used_range.select()