IXlSheetViewOptions.ShowGridLines Property

Gets or sets whether worksheet gridlines are visible.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

bool ShowGridLines { get; set; }

VB.NET

Property ShowGridLines As Boolean

Property Value

Type	Description
Boolean	true, to display worksheet gridlines; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowGridLines
IXlSheet	.ViewOptions.ShowGridLines

Remarks

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

Example

The example below demonstrates how to control the visibility of worksheet gridlines (the faint lines that separate rows and columns in a worksheet). To do this, use the IXlSheetViewOptions.ShowGridLines property of the IXlSheetViewOptions object that contains worksheet display settings and can be accessed using the IXlSheet.ViewOptions property.

Note

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

GeneralActions.cs

// Create a worksheet. 
using (IXlSheet sheet = document.CreateSheet())
{
    // Hide gridlines on the worksheet.
    sheet.ViewOptions.ShowGridLines = false;
}

GeneralActions.vb

' Create a worksheet. 
Using sheet As IXlSheet = document.CreateSheet()
    ' Hide gridlines on the worksheet.
    sheet.ViewOptions.ShowGridLines = False
End Using

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ShowGridLines property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/GeneralActions.cs#L142

    // Hide gridlines on the worksheet.
    sheet.ViewOptions.ShowGridLines = false;
}

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/GeneralActions.vb#L137

    ' Hide gridlines on the worksheet.
    sheet.ViewOptions.ShowGridLines = False
End Using