LSEG Workspace Excel Addin - C# program load fail

tom_ng
tom_ng Newcomer
edited February 19 in Eikon COM

We are migrating from Excel Eikon to Excel Workspace. Currently, we are using a C# program to automate the process. However, while we can load the Excel Add-in in Eikon, we are unable to load the add-in after switching to Workspace.

Here is a sample of our C# code:

using Excel = Microsoft.Office.Interop.Excel;        
Excel.Application objApp = null;
objApp = new Excel.Application();
objApp.DisplayAlerts = true;
objApp.Visible = true;

The Excel process runs, but it does not load the Workspace add-in tab. After checking the add-in status, it shows the error: "Not loaded. A runtime error occurred during the loading of the COM add-in."

Is there any way to solve this issue? After searching in the forum, I think my case is similar to this one. Thank you.

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @tom_ng

    Thank you for reaching out to us.

    I have contacted the internal team to investigate this issue.

    I will let you know after receiving any response back from them.

  • M_P
    M_P Newcomer

    Hi tom_ng,

    Hi Jirapongse,

    we are facing the same issue during migration from Eikon to LSEG Workspace. The Excel Com Add-In is missing in our windows powershell automatism scripts when i create an excel.application com object. (Not loaded. A runtime error occurred during the loading of the COM add-in).

    I tried different MS Office versions from 2021 LTSC and LTSC 2024, and also 32 and 64bit versions. The behavior was always the same.

    Do you have any suggestions ?

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @tom_ng

    @M_P

    The product team doesn't support this kind of usage. You may need to raise a feedback to the product team to support this feature in the LSEG Workspace Excel via the Feedback page.

  • M_P
    M_P Newcomer

    Hi tom_ng,

    there is a Workspace-Lite add-in in MS-Office web-add-in store (search for refinitiv). When I instantiate an Excel.Application Object in Powershell the workspace-lite web add-in will load in contrast to the workspace.com add in.

    Give it a try.