HotXLS-dokumentation
Indhold
Startside
Oversigt
TGridToXLS
IXLSWorkbook
Startside
Indhold
Oversigt
grænseflade IXLSBorder
Enhed: lxHandle
Repræsenterer the border of an object
Beskrivelse
IXLSRange object have four discrete borders - left, right, top, and bottom - which can be returned individually or as a group. Use the Borders property to return the Borders collection, which contains all four borders and treats the borders as a unit. Use Borders[Index], where index identifies the border, to return a single border
Egenskaber
Coloregenskab
ColorIndexegenskab
LineStyleegenskab
Weightegenskab
Metoder
SetThemeColormetode — 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)
Eksempel
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
Workbook.Worksheets[1].Range['A1', 'G1'].Borders[xlEdgeBottom].Color := RGB(255, 0, 0);
Copyright © 2010-2026 losLab Software