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("")

Prantik_Biswas

https://community.developers.refinitiv.com/discussion/comment/123375#Comment_123375

@Jirapongse thank you for responding. However, Eikon is being deprecated and me and my team have only Workspace installed in our system. Given this, what would be the Workspace equivalent solution for this issue. Is there a separate add-in for Workspace which will do the trick?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/124178#Comment_124178

Currently, the Workspace Add-in can't be loaded when the Excel is started from the code or script (Excel.Application). The current solution is the LSEG Data Library (Python or .NET) and then populate the retrieved data to Excel.