HotXLS Docs

GridlineColorIndex property

Gets or sets the classic XLS color index used for displayed worksheet gridlines. Read/write Integer.

Syntax

property GridlineColorIndex: Integer;

Description

The value is saved in the worksheet Window2 icvHdr field. The default value is 64, which tells Excel to use the default window foreground color. When a custom index is saved, HotXLS clears the Window2 fDefaultHdr flag so Excel uses the stored color. This property controls only the displayed gridline color; use DisplayGridLines to show or hide gridlines and PageSetup.PrintGridlines to control printed gridlines.

Example

This example sets the displayed gridline color index in the first sheet.

Workbook.Sheets[1].GridlineColorIndex := 23;