Excel.Sheets.Add方法使用

Excel.Sheets.Add(object before,object after,object count,object type)

eg:
//新增表格
Worksheet sheet = workbook.Worksheets.Add(Type.Missing, Globals.ThisAddIn.Application.ActiveSheet, 1, XlSheetType.xlWorksheet);
//设置表名称
sheet.Name = Const.PARAM_SHEETNAME_A;