python调用其他文件的常量,使用Python和win32com访问Excel COM中的枚举常量

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.

解决方案

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