本文整理匯總了C#中NPOI.XSSF.UserModel.XSSFWorkbook.SetActiveSheet方法的典型用法代碼示例。如果您正苦於以下問題:C# XSSFWorkbook.SetActiveSheet方法的具體用法?C# XSSFWorkbook.SetActiveSheet怎麽用?C# XSSFWorkbook.SetActiveSheet使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類NPOI.XSSF.UserModel.XSSFWorkbook
的用法示例。
在下文中一共展示了XSSFWorkbook.SetActiveSheet方法的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();
}
}