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.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

IXlSheetViewOptions ViewOptions { get; }

Property Value

Type Description
IXlSheetViewOptions

An IXlSheetViewOptions object that contains worksheet display options.

Remarks

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®).

XLExport_ViewOptions_ShowGridlines

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

See Also