Skip to main content
A newer version of this page is available. .

How to: Show and Hide Gridlines

Important

The Universal Subscription or an additional Document Server Subscription is required to use this example in production code. Please 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.

Note

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®).

Spreadsheet_Worksheet_ActiveView_ShowGridlines