HotXLS 文档

Item 属性

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

语法

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

说明

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

示例

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);
本示例 is the same to previous

Workbook.Worksheets[1].Range['A1', 'G1'].Borders[xlEdgeBottom].Color := RGB(255, 0, 0);
本示例 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;