
Hi. I need help to be able to use Excel libraries in the Business Central web client.
I am using an On Premise version where I can use dotnet libraries. In the client version it works perfectly, but in the web
client version it fails me both when opening the excel file and creating a new one.
I have the variables initialized as XlApp: DotNet Excel_ApplicationClass and XlWrkSht: DotNet Excel_Worksheet;
My code is as follows:
XlApp: = XlApp.ApplicationClass ();
XlWorkBook: = XlApp.Workbooks (). Add ();
The fault is in .Add (). As I have read in forums, you have to leave it blank to create a default sheet, but I receive the
error wrong format. A variable must be passed to Add (Template: Dotnet "System.Object"). I have tried to pass that type of variable and a text with a template path as it did in the client version, but it does not work in any case. Keep giving error.
Could anyone help me?
Greetings and thanks.
These are working totally different between the 2 clients.
You have to stick with this article