public static void ReorderWorksheets(Workbook wkbk, List<string> orderedWorksheetNames) { List<string> reversedOnPurpose = new List<string>(orderedWorksheetNames); reversedOnPurpose.Reverse(); foreach (string wsName in reversedOnPurpose) { Worksheet ws = wkbk.GetWorksheet(wsName); XL.Worksheet xlWs = ws.XlWorksheet; xlWs.Move(wkbk.XlWorkbook.Sheets[1]); } }
public static void HideWorksheet(Workbook wkbk, string name) { Worksheet ws = wkbk.GetWorksheet(name); ws.Hide(); }