# add Method of Sheets Class Failed

**URL:** <https://www.dynamicsuser.net/t/add-method-of-sheets-class-failed/64708>\
**Category:** Developers Forum\
**Created:** [December 1, 2017, 6:11am UTC](https://www.dynamicsuser.net/t/add-method-of-sheets-class-failed/64708 "2017-12-01T06:11:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akkrahul](https://avatars.discourse-cdn.com/v4/letter/a/f6c823/32.png) [@Akkrahul](https://www.dynamicsuser.net/u/Akkrahul)\
**Post date:** [December 1, 2017, 6:11am UTC](https://www.dynamicsuser.net/t/add-method-of-sheets-class-failed/64708/1 "2017-12-01T06:11:17Z")

</div>

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;