public SetActiveSheet ( int sheetIndex ) : void | ||
sheetIndex | int | |
return | void |
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); wbBack.Close(); } finally { wb.Close(); } }
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(); } }