Docs HotXLS

IXLSBorders-interface

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

Propriétés

Exemple

L'exemple suivant adds a double border to cell A1 on Worksheet one
Workbook.Worksheets[1].Range['A1','A1'].Borders.LineStyle := xlDouble;
L'exemple suivant 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);