Gets or sets a value that indicates whether or not the grid lines are displayed.

[Visual Basic]
Property DisplayGridlines As Boolean
[C#]
bool DisplayGridlines { get; set; }
[C++]
__property bool get_DisplayGridlines();
__property void set_DisplayGridlines(bool );
[JScript]
function get DisplayGridlines() : bool
function set DisplayGridlines(bool);

Property Value

True if grid lines are displayed; otherwise, false.

Remarks

This property affects only displayed grid lines. Use the PageSetup.PrintGridlines property to control the printing of grid lines.

Example

This example toggles the display of gridlines in the first sheet.

[C#]
IWorksheet sheet = book.Worksheets[1];
sheet.DisplayGridlines = !sheet.DisplayGridlines; 

[Visual Basic]
Dim sheet As IWorksheet = book.Worksheets(1)
sheet.DisplayGridlines = Not sheet.DisplayGridlines 

[C++]
IWorksheet* sheet = book->Worksheets->Item[1];
sheet->DisplayGridlines = !sheet->DisplayGridlines; 

See Also

IWorksheet Interface | NativeExcel Namespace | PrintGridlines Property

---