Options

Cannot create an instance of the following .NET...Microsoft.Office.Interop.Excel Version=15.0.0.0

I have to use an excel file as a template, compile it and return it to the user. With previous versions (BC14) I took advantage of "Microsoft.Office.Interop.Excel.dll".
With the BC 17 version, running the same report, I get this error:

"Cannot create an instance of the following .NET Framework object: assembly Microsoft.Office.Interop.Excel, Version = 15.0.0.0, Culture = neutral, PublicKeyToken = 71e9bce111e9429c, type Microsoft.Office.Interop.Excel.ApplicationClass."

I placed the above file in the folder together with the other dlls, I entered the property "al.assemblyProbingPaths" in the settings.json file, with the paths of the dlls.

I defined the types in a dotnet.al file

assembly ("Microsoft.Office.Interop.Excel")
{
PublicKeyToken = '71e9bce111e9429c';
type("Microsoft.Office.Interop.Excel.ApplicationClass"; "ApplicationClassInterop") { }
(...)
}


Execution stops with calling the constructor method of the ApplicationClassInterop class .

ExcelApp := ExcelApp.ApplicationClass;


What can cause the error?
Any suggestions?

Thanks in advance.
Sign In or Register to comment.