Skip to main content

IXlSheet.ViewOptions Property

Provides access to an object that specifies display settings for a worksheet.

Namespace: DevExpress.Export.Xl

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

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design


IXlSheetViewOptions ViewOptions { get; }

Property Value

Type Description

An IXlSheetViewOptions object that contains worksheet display options.


Use the IXlSheetViewOptions object’s members to specify the visibility of gridlines (IXlSheetViewOptions.ShowGridLines), show or hide row and column headers (IXlSheetViewOptions.ShowRowColumnHeaders), show formulas in cells instead of their calculated results (IXlSheetViewOptions.ShowFormulas), display zero values as blank cells (IXlSheetViewOptions.ShowZeroValues), and make outline symbols in an outlined worksheet invisible (IXlSheetViewOptions.ShowOutlineSymbols).

For example, the image below shows the worksheet when gridlines are displayed, and when gridlines are hidden (the workbook is opened in Microsoft® Excel®).


To specify print settings for a worksheet, use the IXlSheet.PrintOptions, IXlSheet.PageSetup and IXlSheet.PageMargins properties.

See Also