C# 创建Sheet

            object missing = System.Reflection.Missing.Value;
            Excel.Application myExcel = new Excel.Application();

            Microsoft.Office.Interop.Excel._Workbook xBk;                //工作薄 
            Microsoft.Office.Interop.Excel._Worksheet xSt;      //工作Sheet    

            xBk = myExcel.Workbooks.Add(true);

            xSt = (Microsoft.Office.Interop.Excel._Worksheet)xBk.ActiveSheet;
            xSt.Name = "Sheet名称";

            myExcel.Cells[1,1] = tab.Rows[j][k].ToString();//写入内容   Excel从1开始

            myExcel.Sheets.Add(missing, missing, 1, Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet);//添加

            myExcel.Visible = true;
            xBk.SaveAs(@"d:Excel名称.xls", missing, missing,
            missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared,
            missing, missing, missing, missing, missing);//保存文档信息
            myExcel.Quit();
            GC.Collect();