WorkbookPrintOptions.PrintSheetVisibility Property

Gets or sets the visibility of worksheets to be printed.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

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:

Library	Object Type	Path to PrintSheetVisibility
WinForms Controls	SpreadsheetControlOptions	.Print.PrintSheetVisibility
Office File API	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