public Worksheet AddSheetToLastIndex(string sheetName) { Worksheet lastSheet = (Worksheet)WBook.Sheets[WBook.Sheets.Count]; Worksheet xSt1 = (Microsoft.Office.Interop.Excel.Worksheet)WBook.Sheets.Add(Type.Missing, lastSheet, 1, Type.Missing); xSt1.Name = sheetName; xSt1.Activate(); return(xSt1); }
/// <summary> /// 激活工作表 /// </summary> /// <param name="sheetNum">工作表序号</param> public void ActivateSheet(int sheetNum) { Excel.Worksheet worksheet = (Excel.Worksheet)myExcel.Worksheets[sheetNum]; worksheet.Activate(); }
/// <summary> /// 激活工作表 /// </summary> /// <param name="sheetName">工作表名</param> public void ActivateSheet(string sheetName) { Excel.Worksheet worksheet = (Excel.Worksheet)myExcel.Worksheets[sheetName]; worksheet.Activate(); }