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)

[Larz60+]

see: https://python-forum.io/thread-34648.html (your other thread)
I'm not a regular windows user so not sure if pywin32com is same, but is suspect so.

[snippsat]

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

>>> import win32com.client as wc
>>> 
>>> dir(wc)
['CDispatch',
 'CLSIDToClass',
 'CastTo',
 'CoClassBaseClass',
 'Constants',
 'Dispatch',
 'DispatchBaseClass',
 'DispatchEx',
 'DispatchWithEvents',
 'EventsProxy',
 'GetActiveObject',
 'GetObject',
 'Moniker',
 'Record',
 'VARIANT',
 'WithEvents',
 '_PyIDispatchType',
 '__WrapDispatch',
 '__builtins__',
 '__cached__',
 '__doc__',
 '__file__',
 '__loader__',
 '__name__',
 '__package__',
 '__path__',
 '__spec__',
 '_event_setattr_',
 '_get_good_object_',
 '_get_good_single_object_',
 'build',
 'constants',
 'dynamic',
 'gencache',
 'getevents',
 'pythoncom',
 'pywintypes',
 'sys']
>>> 
>>> dir(wc.constants)
['__class__',
 '__delattr__',
 '__dict__',
 '__dicts__',
 '__dir__',
 '__doc__',
 '__eq__',
 '__format__',
 '__ge__',
 '__getattr__',
 '__getattribute__',
 '__gt__',
 '__hash__',
 '__init__',
 '__init_subclass__',
 '__le__',
 '__lt__',
 '__module__',
 '__ne__',
 '__new__',
 '__reduce__',
 '__reduce_ex__',
 '__repr__',
 '__setattr__',
 '__sizeof__',
 '__str__',
 '__subclasshook__',
 '__weakref__']
>>> 
>>> help(wc.constants)
Help on Constants in module win32com.client object:

class Constants(builtins.object)
 |  A container for generated COM constants.
 |  
 |  Methods defined here:
 |  
 |  __getattr__(self, a)
 |  
 |  __init__(self)
 |      Initialize self.  See help(type(self)) for accurate signature.
 |  
 |  ----------------------------------------------------------------------
 |  Data descriptors defined here:
 |  
 |  __dict__
 |      dictionary for instance variables (if defined)
 |  
 |  __weakref__
 |      list of weak references to the object (if defined)

Using a good Editor(eg VS Code) or REPL function/method(with help) will automatic show when type wc.