Problem connecting to excel PowerlinkCOMAddIn.COMAddIn using python win32com.clieny

Prantik_Biswas

I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below.

Here's the code I am using:

import win32com.client

excel = win32com.client.Dispatch("Excel.Application")

wb = excel.Workbooks.Add()

excel.COMAddIns("PowerlinkCOMAddIn.COMAddIn").Connect = True

The last line results in the following error:

com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2147467260), None)

How do I resolved this error?

Jirapongse

@Prantik_Biswas

Thank you for reaching out to us.

I got the same error while running the code. My machine have both Eikon and Workspace installed.

However, after uninstalling Workspace, the code can run properly.

As far as I know, Workspace Excel doesn't support the Eikon COM API anymore. Please contact the helpdesk team via MyAccount to confirm this.

You may run the following code to verify the available AddIns.

import win32com.client

excel = win32com.client.Dispatch("Excel.Application")

for addin in excel.COMAddIns:
    print(addin.description)
    print(addin.connect)
    print(addin.Guid)
    print(addin.ProgId)
    print("")