Class HiddenState

Enum that represents visibility of the worksheet.

Inheritance

System.Object

HiddenState

Namespace: IronXL.Options

Assembly: IronXL.dll

Syntax

public sealed class HiddenState : Enum

HiddenState selects how visible a worksheet is within a workbook, set on a worksheet's visibility. Visible is the normal state, where the tab shows and a user can switch to it. Hidden removes the tab from view but lets a user unhide it through Excel, while VeryHidden conceals the sheet so it cannot be unhidden through the interface and only code can restore it, which suits sheets holding lookup data a user should not see. The manage worksheets how-to covers showing and hiding sheets.

worksheet.State = HiddenState.VeryHidden;

Fields

Hidden

Worksheet is hidden.

Declaration

public const HiddenState Hidden

Field Value

Type	Description
HiddenState

value__

Declaration

public int value__

Field Value

Type	Description
System.Int32

VeryHidden

Worksheet is very hidden.

Declaration

public const HiddenState VeryHidden

Field Value

Type	Description
HiddenState

Visible

Worksheet is visible.

Declaration

public const HiddenState Visible

Field Value

Type	Description
HiddenState