What can you do with COM/ActiveX in Python? [closed]

by

First you have to install the wonderful pywin32 module.

It provides COM support. You need to run the makepy utility. It is located at C:\...\Python26\Lib\site-packages\win32com\client. On Vista, it must be ran with admin rights.

This utility will show all available COM objects. You can find yours and it will generate a python wrapper for this object.

The wrapper is a python module generated in the C:\...\Python26\Lib\site-packages\win32com\gen_py folder. The module contains the interface of the COM objects. The name of the file is the COM unique id. If you have many files, it is sometimes difficult to find the right one.

After that you just have to call the right interface. It is magical 🙂

A short example with excel

import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
xlApp.Visible=1

workBook = xlApp.Workbooks.Open(r"C:\MyTest.xls")
print str(workBook.ActiveSheet.Cells(i,1))
workBook.ActiveSheet.Cells(1, 1).Value = "hello"                
workBook.Close(SaveChanges=0) 
xlApp.Quit()

More Related Contents:

  1. How do I watch a file for changes?
  2. PyWin32 and Python 3.8.0
  3. How to get Windows’ special folders for currently logged-in user?
  4. import win32api error in Python 2.6
  5. Symlinks on windows?
  6. GetWindowRect too small on Windows 7
  7. ImportError: No module named pywintypes
  8. Get other running processes window sizes in Python
  9. Write image to Windows clipboard in python with PIL and win32clipboard?
  10. Screenshot of inactive window PrintWindow + win32gui
  11. How to fix “ImportError: DLL load failed” while importing win32api
  12. Python 3.4 :ImportError: no module named win32api
  13. Win32api is not giving the correct coordinates with GetCursorPos() in python
  14. Create a list of names whose height is higher than 160 – Explanation on nested dicts cycling [closed]
  15. How to flush the input stream?
  16. Python creating a dictionary of lists
  17. Removing Duplicates From Dictionary
  18. How do I automatically fix an invalid JSON string?
  19. Python – Module Not Found
  20. TypeError: only length-1 arrays can be converted to Python scalars while trying to exponentially fit data
  21. How to convert a Scikit-learn dataset to a Pandas dataset
  22. How to create a password entry field using Tkinter
  23. matplotlib: colorbars and its text labels
  24. “Nothing to repeat” from Python regex
  25. cursor.fetchall() vs list(cursor) in Python
  26. SOAP suds and the dreaded schema Type Not Found error
  27. Dictionary vs Object – which is more efficient and why?
  28. How to add an attention mechanism in keras?
  29. sys.stdin.readline() and input(): which one is faster when reading lines of input, and why?
  30. Writing code translator from Python to C? [closed]

Leave a Comment