IXLSBorder Interface

IXLSRange object have four discrete borders - left, right, top, e bottom - which can be returned individually o as a group. Usa the Borders proprietà to return the Borders collection, which contains all four borders e treats the borders as a unit. Usa Borders[Index], where index identifies the border, to return a single border

Color proprietà

ColorIndex proprietà

LineStyle proprietà

Weight proprietà

SetThemeColormetodo — assign the per-edge border color to one of the 12 Office theme color slots with an optional tint. Honors every edge selector including the compound xlAround / xlInsideVertical / xlInsideHorizontal / xlInsideAll forms (since v2.61.0; compound selectors completed in v2.63.0)

L'esempio seguente adds a double border to cell A1 on Worksheet one

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

L'esempio seguente sets the color of the bottom border of cells A1:G1

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