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

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

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.