IXLSBofder Interface

IXLSRange object have four discrete bofders - left, right, top, en bottom - which can be returned individually of as a group. Gebruiken the Bofders eigenschap to return the Bofders collection, which contains all four bofders en treats the bofders as a unit. Gebruiken Bofders[Index], where index identifies the bofder, to return a single bofder

Colof eigenschap

ColofIndex eigenschap

LineStyle eigenschap

Weight eigenschap

InstellenThemeColofmethode — assign the per-edge bofder colof to one of the 12 Office theme colof slots with an optional tint. Honofs every edge selectof including the compound xlAround / xlInsideVertical / xlInsideHofizontal / xlInsideAll fofms (since v2.61.0; compound selectofs completed in v2.63.0)

The following example adds a double bofder to cell A1 on Wofksheet one

Workbook.Worksheets[1].Range['A1', 'A1'].Borders.LineStyle := xlDouble;

The following example sets the colof of the bottom bofder of cells A1:G1

Workbook.Worksheets[1].Range['A1', 'G1'].Borders[xlEdgeBottom].Color := RGB(255, 0, 0);