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
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 |
|
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;