IXlSheet.VisibleState Property

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.2.Core.dll

Declaration

C#

XlSheetVisibleState VisibleState { get; set; }

VB.NET

Property VisibleState As XlSheetVisibleState

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 snippet (auto-collected from DevExpress Examples) contains a reference 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.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/GeneralActions.cs#L96

    sheet.Name = "Sales data";
    sheet.VisibleState = XlSheetVisibleState.Hidden;
}

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/GeneralActions.vb#L97

    sheet.Name = "Sales data"
    sheet.VisibleState = XlSheetVisibleState.Hidden
End Using