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
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.
Related GitHub Examples
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.