HotXLS Docs
Home Contents Overview

IXLSBorders Interface

Unit: lxHandle
Collection of four IXLSBorder objects that represent the four borders of a IXLSRange object. Usa the Borders proprietà to return the Borders collection, which contains all four borders. Usa Borders[index], where index identifies the border, to return a single IXLSBorder object

Properties

Color proprietà
ColorIndex proprietà
LineStyle proprietà
Weight proprietà
Item proprietà

Example

The following example adds a double border to cell A1 on Worksheet one 
Workbook.Worksheets[1].Range['A1','A1'].Borders.LineStyle := xlDouble;
The following example sets the color of the bottom border of cells A1:G1 to red 
Workbook.Worksheets[1].Range['A1','G1'].Borders[xlEdgeBottom].Color := RGB(255, 0, 0);