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.
0