TExcelFile.DrawBorders Method
This method draws a border around a range of cells.
Remarks
This is just a shortcut for calling SetCellFormat(Integer, Integer, Integer, Integer, TFlxFormat, TFlxApplyFormat, Boolean)
Syntax
Unit: FlexCel.Core
procedure TExcelFile.DrawBorders(const row1: Integer; const col1: Integer; const row2: Integer; const col2: Integer; const borderStyle: TFlxBorderStyle; const borderColor: TExcelColor; const exteriorBorders: Boolean);
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row1 | Integer | Row index of the top cell on the range (1 based) |
const | col1 | Integer | Column index of the left cell on the range (1 based) |
const | row2 | Integer | Row index of the bottom cell on the range (1 based) |
const | col2 | Integer | Column index of the right cell on the range (1 based) |
const | borderStyle | TFlxBorderStyle | Style of the border to draw. |
const | borderColor | TExcelColor | Color of the border to draw. |
const | exteriorBorders | Boolean | When true, the format for the border will be applied only to the outer cells in the range. This can be useful for example to draw a box around a range of cells, but not drawing borders inside the range. |