The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Show and Hide Gridlines

Important

You require 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.

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