C# winform 创建Excel 如何创建多个sheet?急 50分

Question

如题，请各位给于解决

Answer 1

/// <summary>
/// 创建Excel工作表
/// </summary>
/// <param name="xBook"></param>
/// <param name="index"></param>
/// <returns></returns>
public static Excel.Worksheet CreatWorkSheet(Excel.Workbook xBook, int index)
{
if(xBook == null)
return null;
try
{
if(index <= xBook.Sheets.Count)
return (Excel.Worksheet)xBook.Sheets[index];
return (Excel.Worksheet)xBook.Sheets.Add(Missing.Value, xBook.Sheets[xBook.Worksheets.Count], 1, Type.Missing);
}
catch
{
Close();
return null;
}}