Search code examples
excelpython-2.7win32com

Accessing enumeration constants in Excel COM using Python and win32com


I'm using python 2.7 win32com module to load an MS Excel worksheet from Python:

    book = xlApp.Workbooks.Open("myFile.xls")
    sheet = book.Sheets(1)

Many methods and properties of Range, Worksheet etc use enumerations like XlDirection, XlFillWith, and so forth. These define constants such as xlDown, xlUp, xlFillWithContents, etc. Are those constants available from win32com so that I could do, for example:

    column = outputsSheet.Range("I5:I150")
    lastRow = column.End(xlInterop.xlDown)
    print "Last row:", lastRow.Row

This doesn't work because xlInterop is not defined, is there a way to access it using win32com? Discovering the values of such constants as xlDown by trial and error is not very practical.


Solution

  • I'm new to win32com, so I don't know if this helps... try to start Excel with:

    xlApp = win32com.client.gencache.EnsureDispatch("Excel.Application")
    

    This should run makepy, and you can find some resulting Python files in ...\Lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x7 (last folder might be another name for you, I dont know). Check the init.py file, there's a bunch of constants defined there.

    Edit: you can access these constants with:

    from win32com.client import constants as c
    

    Edit2: path to folder:

    win32com.__gen_path__