Add sheet to workbook

[Dorte]

Hi,

In a .net console application in C#, I need to create excel files, workbooks
and add sheets to the workbook.
I have added a reference to Microsoft Excel 10.0 object library.

But I get a COM exception when I try to add a sheet to the workbook. Here is
my code:

Excel.Application ExcelApp = new Application();

// bug work around, due to local settings different than English version of
Excel
System.Threading.Thread.CurrentThread.CurrentCulture = new
System.Globalization.CultureInfo("en-US");

Excel.Workbook book1 = ExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
book1.Sheets.Add(null, book1.Sheets[1], 1, XlSheetType.xlWorksheet);

The last line of code generates the following error:
Exception from HRESULT: 0x800A03EC
error code:-2146827284

Could anyone tell me how I can add sheets to the workbook without getting an
error?

Thanks,
Dorte

 

[Jon Peltier]

Please post in a relevant group.

- Jon