How to: Show and Hide Gridlines

• Apr 12, 2019

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

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