Excel libraries in the Business Central web client

(0) Share

Report

Posted on by Antonio Llanero

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.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

THE Italian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

These are working totally different between the 2 clients.

You have to stick with this article

www.kauffmann.nl/.../

Was this reply helpful? Yes No