HotXLS-dokumentation
Innehåll
Startsida
Översikt
TGridToXLS
IXLSWorkbook
Startsida
Innehåll
Översikt
Item egenskap
Returnerar a IXLSBorder object that represents one of the borders of a range of cells
Syntax
property Item[Index: LongWord]: IXLSBorder; default;
Index
XlBordersIndex
Beskrivning
XlBordersIndex can be one of these XlBordersIndex constants
xlEdgeBottom
xlEdgeLeft
xlEdgeRight
xlEdgeTop
xlAround
xlInsideHorizontal
xlInsideVertical
xlInsideAll
xlDiagonalDown
xlDiagonalUp
Exempel
This following example sets the color of the bottom border of cells A1:G1
Workbook.Worksheets[1].Range['A1', 'G1'].Borders.Item[xlEdgeBottom].Color := RGB(255, 0, 0);
This example is the same to previous
Workbook.Worksheets[1].Range['A1', 'G1'].Borders[xlEdgeBottom].Color := RGB(255, 0, 0);
This example adds a thick red border around the range A1:D4 on Sheet1
with Workbook.Worksheets[1].Range['A1', 'D4'].Borders[xlAround] do begin
ColorIndex:=3;
Weight:=xlThick;
end;
Copyright © 2010-2026 losLab Software