Package org.apache.poi.ss.usermodel
Enum Class SheetVisibility
- All Implemented Interfaces:
Serializable
,Comparable<SheetVisibility>
,Constable
Specifies sheet visibility
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>>
-
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionIndicates the book window is hidden, but can be shown by the user via the user interface.Indicates the sheet is hidden and cannot be shown in the user interface (UI).Indicates the sheet is visible. -
Method Summary
Modifier and TypeMethodDescriptionstatic SheetVisibility
Returns the enum constant of this class with the specified name.static SheetVisibility[]
values()
Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
VISIBLE
Indicates the sheet is visible. -
HIDDEN
Indicates the book window is hidden, but can be shown by the user via the user interface. -
VERY_HIDDEN
Indicates the sheet is hidden and cannot be shown in the user interface (UI).In Excel this state is only available programmatically in VBA:
ThisWorkbook.Sheets("MySheetName").Visible = xlSheetVeryHidden
-
-
Method Details
-
values
Returns an array containing the constants of this enum class, in the order they are declared.- Returns:
- an array containing the constants of this enum class, in the order they are declared
-
valueOf
Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException
- if this enum class has no constant with the specified nameNullPointerException
- if the argument is null
-