C# Import Excel - XlWBATemplate.XlWBATWorksheet Error

Hello,

I am trying to create a new Excel file with a blank sheet.
My code is the following :

using Excel = Microsoft.Office.Interop.Excel;

public void format()
{
List sheets = getSheetName(path);

Excel._Application xlsAppNew = new Excel.Application();
xlsAppNew.Visible = true;

foreach (string s in sheets)
{

if (s.Contains("A,B") == true)
{
char[] delim = { 'A' };

string[] grupa = s.Split(delim, 4);

listView1.Items.Add(grupa[0] + "A");
Excel.Workbook workbook = Excel.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Excel.Sheets newSheet = workbook.Worksheets;

listView1.Items.Add(grupa[0] + "B");
//save in another sheet

}
else
listView1.Items.Add(s.ToString());
//save in another sheet
}
}

But I get the following error : The name 'XlWBATemplate' does not exist in the current context.
What`s missing?

Please help.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

diana onea15y ago
I found the problem. I used the functions wrong...the correct code is :

Excel.Workbook newWorkbook = xlsAppNew.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);

Thank you all !!...
0
Suthish Nair15y ago
XlWBATemplate - object missing. can you post the samples you referning..
0