Skip to content
Advertisement

Tag: com

Python win32com constants

I’m currently wondering how to list the constants in win32com in python, for example using excel win32com.client.Dispatch(‘Excel.Application’) Is there a way to display all constants using win32com.client.Constants ? Or does someone know where i could find win32com’s documentation ? Because all the links I found are dead … Answer To find out what Com applications you can use… See http://timgolden.me.uk/pywin32-docs/html/com/win32com/HTML/QuickStartClientCom.html

python win32 COM closing excel workbook

I open several different workbooks (excel xlsx format) in COM, and mess with them. As the program progresses I wish to close one specific workbook but keep the rest open. How do I close ONE workbook? (instead of the entire excel application) Answer The the Workbook COM object has a Close() method. Basically, it should be something like: The above

Advertisement