win32com.client.Dispatch + Cherrypy = CoInitialize has not been called

python python-3.x cherrypy win32com
stenci picture stenci · Nov 4, 2014 · Viewed 9.9k times · Source

The following code works well, but it fails if executed from a CherryPy app method with the error message CoInitialize has not been called:

import win32com.client
xl = win32com.client.Dispatch("Excel.Application")
xl.quit()

This post suggests a solution that works for me:

import pythoncom
pythoncom.CoInitialize()

The reason I'm asking about a problem for which I already have a solution, is that (1) I would like to know what I'm doing (rather than doing it only because I've seen it working once) and (2) I don't want to risk to miss something important (and reading this post makes me think that I am missing something.)

I couldn't find any documentation for pythoncom.CoInitialize(), and the source of pythoncom is the following three lines that don't help me (nor Eclipse+pydev which says that the method does not exist):

# Magic utility that "redirects" to pythoncomxx.dll
import pywintypes
pywintypes.__import_pywin32_system_module__("pythoncom", globals())

Answer

saaj picture saaj · Nov 5, 2014

I can't remember exactly as I didn't work with COM last years but I guess that you have to initialize COM in every thread you work with it (again I'm not sure about every COM compartment). As CherryPy is threaded servers your requests are handled by different threads, not one you bootstrap with. So I suggest you to try the following in your bootstrap routine:

import pythoncom


def onThreadStart(threadIndex):
  pythoncom.CoInitialize()

cherrypy.engine.subscribe('start_thread', onThreadStart)

Related questions

Convert bytes to a string

I'm using this code to get standard output from an external program: >>> from subprocess import * >>> command_stdout = Popen(['ls', '-l'], stdout=PIPE).communicate()[0] The communicate() method returns an array of bytes: >>> …

Read More
Best way to convert string to bytes in Python 3?

There appear to be two different ways to convert a string to bytes, as seen in the answers to TypeError: 'str' does not support the buffer interface Which of these methods would be better or more Pythonic? Or is it …

Read More
How to install pip with Python 3?

I want to install pip. It should support Python 3, but it requires setuptools, which is available only for Python 2. How can I install pip with Python 3?

Read More