win32com — How to resolve “AttributeError: xlUp” for Excel files?

[JaneTan]

Similar to Excel VBA, win32com has a 'xlUp' command. But do I use it? I tried the below code but get
AttributeError: xlUp

Or how do I find all the methods available in a Python library? Thanks in advance!

import win32com.client as wc

xl=wc.DispatchEx("Excel.Application")
wb=xl.Workbooks.Open(Filename='TEST', ReadOnly=False, UpdateLinks=0, IgnoreReadOnlyRecommended=True)
ws=wb.Worksheets('sht1')

print(ws.cells(ws.rows.count, 1).End(wc.constants.xlUp).Address)