Skip to main content

IXlSheet.VisibleState Property

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

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the VisibleState property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also