HotXLS Docs

Borders property

Returns a IXLSBorders collection that represents the borders of a range of cells.

Syntax

property Borders: IXLSBorders;

Example

This example sets the color of the bottom border of cell B2 on sheet one to a thin red border.

With Workbook.Worksheets[1].Range['B2', 'B2'].Borders[xlEdgeBottom] do
begin
  LineStyle := xlContinuous;
  Weight := xlThin;
  ColorIndex := 3;
end;