Enum Class SheetVisibility

java.lang.Object
java.lang.Enum<SheetVisibility>
org.apache.poi.ss.usermodel.SheetVisibility
All Implemented Interfaces:
Serializable, Comparable<SheetVisibility>, Constable

public enum SheetVisibility extends Enum<SheetVisibility>
Specifies sheet visibility
See Also:
  • Enum Constant Details

    • VISIBLE

      public static final SheetVisibility VISIBLE
      Indicates the sheet is visible.
    • HIDDEN

      public static final SheetVisibility HIDDEN
      Indicates the book window is hidden, but can be shown by the user via the user interface.
    • VERY_HIDDEN

      public static final SheetVisibility 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

      public static SheetVisibility[] 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

      public static SheetVisibility valueOf(String name)
      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 name
      NullPointerException - if the argument is null