.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

How to: Show and Hide Gridlines


You need a license to the DevExpress Office File API or DevExpress Universal Subscription to use these examples in production code. Refer to the DevExpress Subscription page for pricing information.

This example demonstrates how to control the visibility of the worksheet gridlines. To do this, use the WorksheetView.ShowGridlines property of the worksheet view object that is accessed via the Worksheet.ActiveView property.


To specify whether the worksheet gridlines should be printed, use the WorksheetPrintOptions.PrintGridlines property of the object accessed via Worksheet.PrintOptions. Refer to the How to: Specify Print Settings document for details on how to specify print options for a worksheet.

// Hide gridlines on the first worksheet.
workbook.Worksheets[0].ActiveView.ShowGridlines = false;

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