| Package | Description | 
|---|---|
| org.apache.poi.hssf.model | Provides low level API structures for reading, writing, modifying XLS files. | 
| org.apache.poi.hssf.usermodel | The usermodel package maps HSSF low level structures to familiar workbook/sheet model | 
| org.apache.poi.ss.usermodel | |
| org.apache.poi.xssf.streaming | |
| org.apache.poi.xssf.usermodel | 
| Modifier and Type | Method and Description | 
|---|---|
| SheetVisibility | InternalWorkbook. getSheetVisibility(int sheetnum)Gets the hidden flag for a given sheet. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | InternalWorkbook. setSheetHidden(int sheetnum,
              SheetVisibility visibility)Hide or unhide a sheet. | 
| Modifier and Type | Method and Description | 
|---|---|
| SheetVisibility | HSSFWorkbook. getSheetVisibility(int sheetIx) | 
| Modifier and Type | Method and Description | 
|---|---|
| void | HSSFWorkbook. setSheetVisibility(int sheetIx,
                  SheetVisibility visibility) | 
| Modifier and Type | Method and Description | 
|---|---|
| SheetVisibility | Workbook. getSheetVisibility(int sheetIx)Get the visibility (visible, hidden, very hidden) of a sheet in this workbook | 
| static SheetVisibility | SheetVisibility. valueOf(java.lang.String name)Returns the enum constant of this type with the specified name. | 
| static SheetVisibility[] | SheetVisibility. values()Returns an array containing the constants of this enum type, in
the order they are declared. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | Workbook. setSheetVisibility(int sheetIx,
                  SheetVisibility visibility)Hide or unhide a sheet. | 
| Modifier and Type | Method and Description | 
|---|---|
| SheetVisibility | SXSSFWorkbook. getSheetVisibility(int sheetIx) | 
| Modifier and Type | Method and Description | 
|---|---|
| void | SXSSFWorkbook. setSheetVisibility(int sheetIx,
                  SheetVisibility visibility) | 
| Modifier and Type | Method and Description | 
|---|---|
| SheetVisibility | XSSFWorkbook. getSheetVisibility(int sheetIx) | 
| Modifier and Type | Method and Description | 
|---|---|
| void | XSSFWorkbook. setSheetVisibility(int sheetIx,
                  SheetVisibility visibility) | 
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.