Back to Devexpress

WorkbookPrintOptions.PrintSheetVisibility Property

officefileapi-devexpress-dot-xtraspreadsheet-dot-workbookprintoptions.md

latest2.4 KB
Original Source

WorkbookPrintOptions.PrintSheetVisibility Property

Gets or sets the visibility of worksheets to be printed.

Namespace : DevExpress.XtraSpreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
[DefaultValue(WorksheetVisibilityType.Visible)]
[XtraSerializableProperty]
public WorksheetVisibilityType PrintSheetVisibility { get; set; }
vb
<DefaultValue(WorksheetVisibilityType.Visible)>
<XtraSerializableProperty>
Public Property PrintSheetVisibility As WorksheetVisibilityType

Property Value

TypeDefaultDescription
WorksheetVisibilityTypeVisible

An enumeration member that indicates the worksheet visibility.

|

Available values:

NameDescription
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 TypePath to PrintSheetVisibility
DocumentOptions

.Print .PrintSheetVisibility

|

Remarks

The following code prints only hidden worksheets in a workbook:

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

See Also

WorkbookPrintOptions Class

WorkbookPrintOptions Members

DevExpress.XtraSpreadsheet Namespace