officefileapi-devexpress-dot-spreadsheet-dot-worksheetview-45775ecf.md
Gets or sets whether worksheet gridlines are visible.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool ShowGridlines { get; set; }
Property ShowGridlines As Boolean
| Type | Description |
|---|---|
| Boolean |
true to display worksheet gridlines; otherwise, false.
|
The image below shows the worksheet when gridlines are displayed, and when gridlines are hidden (the workbook is opened in Microsoft® Excel®).
Use the Worksheet.ActiveView.ShowGridlines property to display or hide worksheet gridlines.
Note
The Worksheet.PrintOptions.PrintGridlines property allows you to specify whether worksheet gridlines should be printed. Refer to the following help topic for more information on how to specify print options for a worksheet: How to: Specify Print Settings.
The following example hides gridlines for the first worksheet in a workbook:
workbook.Worksheets[0].ActiveView.ShowGridlines = false;
workbook.Worksheets(0).ActiveView.ShowGridlines = False
The following code snippets (auto-collected from DevExpress Examples) contain references 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.
// Hide gridlines in the first worksheet.
workbook.Worksheets[0].ActiveView.ShowGridlines = false;
#endregion #ShowHideGridlines
worksheet.ActiveView.ShowGridlines = false;
workbook.EndUpdate();
worksheet.ActiveView.ShowGridlines = false;
workbook.EndUpdate();
// Hide gridlines in the first worksheet.
workbook.Worksheets[0].ActiveView.ShowGridlines = false;
#endregion #ShowHideGridlines
// Hide gridlines on the first worksheet.
workbook.Worksheets[0].ActiveView.ShowGridlines = false;
#endregion #ShowHideGridlines
' Hide gridlines in the first worksheet.
workbook.Worksheets(0).ActiveView.ShowGridlines = False
' #End Region ' #ShowHideGridlines
worksheet.ActiveView.ShowGridlines = False
workbook.EndUpdate()
worksheet.ActiveView.ShowGridlines = False
workbook.EndUpdate()
' Hide gridlines in the first worksheet.
workbook.Worksheets(0).ActiveView.ShowGridlines = False
' #End Region ' #ShowHideGridlines
' Hide gridlines on the first worksheet.
workbook.Worksheets(0).ActiveView.ShowGridlines = False
#End Region ' #ShowHideGridlines
See Also