使用VSTO新建一个sheet

Excel.Worksheet newSheet = Globals.ThisWorkbook.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value) as Excel.Worksheet;

newSheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetVisible;//设置是否可见

newSheet.Name = "新建工作表";//设置sheet名称