Skip to main content

XlPrintOptions.GridLines Property

Gets or sets a value indicating whether worksheet gridlines should be printed.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public bool GridLines { get; set; }

Property Value

Type Description
Boolean

true, to print worksheet gridlines; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to GridLines
IXlSheet
.PrintOptions .GridLines

Remarks

Use the GridLines property to specify whether or not to include gridlines in the worksheet printout. To control the visibility of gridlines in the worksheet view, use the IXlSheetViewOptions.ShowGridLines property of the object accessible from the IXlSheet.ViewOptions property.

To learn more about how to specify various print-related options, refer to the How to: Specify Print Settings example.

Example

The example below demonstrates how to specify print settings for a worksheet.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Specify print options for the worksheet.
sheet.PrintOptions = new XlPrintOptions();
// Print row and column headings.
sheet.PrintOptions.Headings = true;
// Print gridlines.
sheet.PrintOptions.GridLines = true;
// Center worksheet data on a printed page.
sheet.PrintOptions.HorizontalCentered = true;
sheet.PrintOptions.VerticalCentered = true;
See Also