IXlSheet.VisibleState Property

Gets or sets whether the current worksheet is visible, hidden or “very hidden”.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.1.Core.dll

Declaration

XlSheetVisibleState VisibleState { get; set; }

Property Value

Type Description
XlSheetVisibleState

An XlSheetVisibleState enumeration member that specifies the worksheet visibility type

Available values:

Name Description
Visible

A worksheet is visible.

Hidden

A worksheet is hidden.

VeryHidden

A worksheet is hidden and cannot be unhidden from the user interface.

Remarks

Set the VisibleState property to XlSheetVisibleState.Hidden to hide the worksheet. Set it to XlSheetVisibleState.Visible to display the hidden worksheet again.

Also, the VisibleState property provides you with the capability to make the worksheet “very hidden” (XlSheetVisibleState.VeryHidden). This is a specific mode that does not allow the worksheet to be shown again by end-users. To make a “very hidden” worksheet visible again, set the VisibleState property to XlSheetVisibleState.Visible.

Note

A workbook must always contain at least one visible worksheet.

See Also