本文整理汇总了C#中IWorkbook.SetSheetOrder方法的典型用法代码示例。如果您正苦于以下问题：C# IWorkbook.SetSheetOrder方法的具体用法？C# IWorkbook.SetSheetOrder怎么用？C# IWorkbook.SetSheetOrder使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IWorkbook的用法示例。
在下文中一共展示了IWorkbook.SetSheetOrder方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RemoveAllSheetsBut
private static void RemoveAllSheetsBut(int sheetIndex, IWorkbook wb)
{
int sheetNb = wb.NumberOfSheets;
// Move this sheet at the first position
wb.SetSheetOrder(wb.GetSheetName(sheetIndex), 0);
for (int sn = sheetNb - 1; sn > 0; sn--)
{
wb.RemoveSheetAt(sn);
}
}示例2: RemoveAllSheetsBut
// public void Test57165b(){
// IWorkbook wb = new XSSFWorkbook();
// try {
// wb.CreateSheet("New Sheet 1");
// wb.CreateSheet("New Sheet 2");
// } finally {
// wb.Close();
// }
// }
private static void RemoveAllSheetsBut(int sheetIndex, IWorkbook wb)
{
int sheetNb = wb.NumberOfSheets;
// Move this sheet at the first position
wb.SetSheetOrder(wb.GetSheetName(sheetIndex), 0);
// Must make this sheet active (otherwise, for XLSX, Excel might protest that active sheet no longer exists)
// I think POI should automatically handle this case when deleting sheets...
// wb.SetActiveSheet(0);
for (int sn = sheetNb - 1; sn > 0; sn--)
{
wb.RemoveSheetAt(sn);
}
}