WorkbookPrintOptions.PrintSheetVisibility Property

Gets or sets the visibility of worksheets to be printed.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.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:

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