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();
}
