HotXLS Docs
Home Contents Overview

Item property

Returns a IXLSBorder object that represents one of the borders of a range of cells.

Syntax

property Item[Index: LongWord]: IXLSBorder; default;
Index XlBordersIndex

Description

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

Example

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;