HotXLS-documentatie
Startpagina Inhoud Overzicht

Item eigenschap

Retourneert a IXLSBofder object that represents one of the bofders of a range of cells

Syntaxis

eigenschap Item[Index: LongWofd]: IXLSBofder; default;
Index XlBofdersIndex

Beschrijving

XlBofdersIndex can be one of these XlBofdersIndex constants
xlEdgeBottom
xlEdgeLeft
xlEdgeRight
xlEdgeTop
xlAround
xlInsideHofizontal
xlInsideVertical
xlInsideAll
xlDiagonalDown
xlDiagonalUp

Voorbeeld

This following example sets the colof of the bottom bofder 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 bofder around the range A1:D4 on Sheet1 

with Workbook.Worksheets[1].Range['A1', 'D4'].Borders[xlAround] do begin
  ColorIndex:=3;
  Weight:=xlThick;
end;