无法将类型对象隐式转换为microsoft.Office.Interop.Excel.Wheet，存在显式转换

Question

public void ExportToexcel(DataSet ds , string strpath)
{
int inheaderleghth = 3, incliomn = 0, inrow = 0;
System.Reflection.Missing Default = System.Reflection.Missing.Value;
strpath += @"";
excel.Application exceApp = new excel.Application();
excel.Workbook excelWorkBook = exceApp.Workbooks.Add(1);
foreach(DataTable dtbl in ds.Tables)
{
//error show below line
excel.Worksheet ecxelworksheet = excelWorkBook.Sheets.Add(Type.Missing, excelWorkBook.Sheets[excelWorkBook.Sheets.Count],1,Default);
}
}

Answer 1

使用软铸造，即

excel.Worksheet ecxelworksheet = excelWorkBook.Sheets.Add(
Type.Missing,
excelWorkBook.Sheets[excelWorkBook.Sheets.Count],
1,Default) as excel.Worksheet;