add Method of Sheets Class Failed

Dynamics 365 Business Central/NAV User Group Developers Forum
#1

Hi All,

When I have generate Multiple excel Sheet Using .Net InterOpratibility, I have got error of “add Method of Sheets Class Failed”. I have using following code …

xlapp := xlapp.ApplicationClass;

xlworkbook := xlapp.Workbooks.Add(’’);

xlWorkSheet := xlworkbook.ActiveSheet;

xlWorkSheet.Name := ‘Sheet1’;

xlWorkSheet1 := xlworkbook.Worksheets.Add(’’,’’,1,’’);

xlWorkSheet1.Name := ‘Sheet2’;

xlapp.Visible := TRUE;