WorkbookPrintOptions.PrintSheetVisibility Property

Gets or sets the visibility of worksheets to be printed.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[DefaultValue(WorksheetVisibilityType.Visible)]
[XtraSerializableProperty]
public WorksheetVisibilityType PrintSheetVisibility { get; set; }

VB.NET

<DefaultValue(WorksheetVisibilityType.Visible)>
<XtraSerializableProperty>
Public Property PrintSheetVisibility As WorksheetVisibilityType

Property Value

Type	Default	Description
WorksheetVisibilityType	Visible	An enumeration member that indicates the worksheet visibility.

Available values:

Name	Description
Visible	A worksheet is visible.
Hidden	A worksheet is hidden.
VeryHidden	A worksheet is hidden and cannot be unhidden via the user interface.

Property Paths

You can access this nested property as listed below:

Object Type	Path to PrintSheetVisibility
DocumentOptions	.Print .PrintSheetVisibility

Remarks

The following code shows how to print only hidden worksheets in a workbook:

C#

workbook.Options.Print.PrintSheetVisibility = WorksheetVisibilityType.Hidden;

VB.NET

workbook.Options.Print.PrintSheetVisibility = WorksheetVisibilityType.Hidden