NPOI.XSSF.UserModel.XSSFWorkbook.SetActiveSheet C# (CSharp) 메소드

SetActiveSheet() 공개 메소드

public SetActiveSheet ( int sheetIndex ) : void
sheetIndex int
리턴 void
        public void SetActiveSheet(int sheetIndex)
        {
            ValidateSheetIndex(sheetIndex);

            
            foreach (CT_BookView arrayBook in workbook.bookViews.workbookView)
            {
                arrayBook.activeTab = (uint)(sheetIndex);
            }
        }
       /**

Usage Example

예제 #1
0
        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();
            }
        }
All Usage Examples Of NPOI.XSSF.UserModel.XSSFWorkbook::SetActiveSheet