Using win32com with multithreading

by

If you want to use win32com in multiple threads you need to do a little bit more work as COMObject cannot be passed to a thread directly. You need to use CoMarshalInterThreadInterfaceInStream() and CoGetInterfaceAndReleaseStream() to pass instance between threads:

import pythoncom, win32com.client, threading, time

def start():
    # Initialize
    pythoncom.CoInitialize()

    # Get instance
    xl = win32com.client.Dispatch('Excel.Application')

    # Create id
    xl_id = pythoncom.CoMarshalInterThreadInterfaceInStream(pythoncom.IID_IDispatch, xl)

    # Pass the id to the new thread
    thread = threading.Thread(target=run_in_thread, kwargs={'xl_id': xl_id})
    thread.start()

    # Wait for child to finish
    thread.join()

def run_in_thread(xl_id):
    # Initialize
    pythoncom.CoInitialize()

    # Get instance from the id
    xl = win32com.client.Dispatch(
            pythoncom.CoGetInterfaceAndReleaseStream(xl_id, pythoncom.IID_IDispatch)
    )
    time.sleep(5)


if __name__ == '__main__':
    start()

For more info see: https://mail.python.org/pipermail/python-win32/2008-June/007788.html

More Related Contents:

  1. Are lists thread-safe?
  2. Freezing/Hanging tkinter GUI in waiting for the thread to complete
  3. PyQt4 Wait in thread for user input from GUI
  4. Threads and tkinter
  5. multiprocessing vs multithreading vs asyncio in Python 3
  6. Multiprocessing causes Python to crash and gives an error may have been in progress in another thread when fork() was called
  7. How to run multiple functions at the same time?
  8. How to use threading in Python?
  9. multiprocessing vs multithreading vs asyncio
  10. Trying to fix tkinter GUI freeze-ups (using threads)
  11. With “args” vs without “args” to pass arguments to a thread in Python
  12. How can I replace comma separated ids in a string by doing a lookup in json response in python
  13. Are dictionaries ordered in Python 3.6+?
  14. error in python d not defined. [duplicate]
  15. Why does the print function return None?
  16. Count frequency of words in a list and sort by frequency
  17. What is vectorization? [closed]
  18. Python cannot handle numbers string starting with 0. Why?
  19. How to start and stop thread?
  20. Using the class as a type hint for arguments in its methods [duplicate]
  21. Why doesn’t Python recognize my utf-8 encoded source file?
  22. How do I include files with pyinstaller?
  23. Accessing items in an collections.OrderedDict by index
  24. How can I see the formulas of an excel spreadsheet in pandas / python?
  25. How to explain the str.maketrans function in Python 3.6?
  26. packing and unpacking variable length array/string using the struct module in python
  27. Changing the “locale preferred encoding” in Python 3 in Windows
  28. filter object becomes empty after iteration? [duplicate]
  29. How do I send data to a running python thread?
  30. “asyncio.run() cannot be called from a running event loop” when using Jupyter Notebook

Leave a Comment