LSEG Workspace Excel Addin - startup load failure from C# app

adriano_lapel

Hello

I try to open Excel workbook with LSEG Workspace COM addin from C# app but it fails to load addin on startup; while if I open same file manually addin loads correctly. please help me to open Excel file with workspace addin active through C#, thanks

jason.ramchandani01

@adriano_lapel Thanks for your question - as this seems to be an in-product excel issue (I think how to configure autoload for Workspace Excel add-in or similar) - I have opened case 13343143 on your behalf and someone will reach out to you shortly. Please let us know how you get on.

adriano_lapel

Thanks, in meantime i solved the issue

bertrand.dumont

can you please share how you solved the issue. I have the same problem. Thanks

adriano_lapel

below sample code, you need to launch excel process and use marshaling, excel interop does not load correctly excel addin

var proc = Process.Start("excel.exe");
Microsoft.Office.Interop.Excel.Application oExcelApp = null;
while (oExcelApp == null)
{
    try
    {
        oExcelApp = (Microsoft.Office.Interop.Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
    }
    catch
    {
        System.Threading.Thread.Sleep(1000);
    }
}
excelApp.Workbooks.Open(...);