Creating new Excel and adding required no. of sheets using .Net variables

Dynamics 365 Business Central/NAV Developers Forum
#1

I’m facing problem in adding additional sheets to an excel .

while executing the below code I’m able to create new excel sheet,

Prob1.png
Prob1.png1362×622 22.7 KB

After creating the excel file I’m not able add additional sheets to that excel.

It is showing error like

prob.png

Please suggest any possible ways of adding sheets.

Thanks in Advance.

#2

Hi,
This should help
saurav-nav.blogspot.in/…/nav-2013-r2-multiple-sheets-in-excel.html

#3

Thanks for your reply,

I have done this already using Excel buffer. But I want it by using .Net variables.