本文整理汇总了C#中NPOI.XSSF.UserModel.XSSFWorkbook.GetSheetIndex方法的典型用法代码示例。如果您正苦于以下问题:C# XSSFWorkbook.GetSheetIndex方法的具体用法?C# XSSFWorkbook.GetSheetIndex怎么用?C# XSSFWorkbook.GetSheetIndex使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类NPOI.XSSF.UserModel.XSSFWorkbook
的用法示例。
在下文中一共展示了XSSFWorkbook.GetSheetIndex方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SetFirstVisibleTab_57373
public void SetFirstVisibleTab_57373()
{
XSSFWorkbook wb = new XSSFWorkbook();
try
{
/*Sheet sheet1 =*/
wb.CreateSheet();
ISheet sheet2 = wb.CreateSheet();
int idx2 = wb.GetSheetIndex(sheet2);
ISheet sheet3 = wb.CreateSheet();
int idx3 = wb.GetSheetIndex(sheet3);
// add many sheets so "first visible" is relevant
for (int i = 0; i < 30; i++)
{
wb.CreateSheet();
}
wb.FirstVisibleTab = (/*setter*/idx2);
wb.SetActiveSheet(idx3);
//wb.Write(new FileOutputStream(new File("C:\\temp\\test.xlsx")));
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
IWorkbook wbBack = XSSFTestDataSamples.WriteOutAndReadBack(wb);
sheet2 = wbBack.GetSheetAt(idx2);
sheet3 = wbBack.GetSheetAt(idx3);
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
}
finally
{
wb.Close();
}
}