Documentazione HotXLS
Home Contenuti Panoramica

Item proprietà

Restituisce a IXLSBorder object that represents one of the borders of a range of cells

Sintassi

proprietà Item[Index: LongWord]: IXLSBorder; default;
Index XlBordersIndex

Descrizione

XlBordersIndex can be one of these XlBordersIndex constants
xlEdgeBottom
xlEdgeLeft
xlEdgeRight
xlEdgeTop
xlAround
xlInsideHorizontal
xlInsideVertical
xlInsideAll
xlDiagonalDown
xlDiagonalUp

Esempio

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;