Table of Contents

ExcelFile.DrawBorders Method

This method draws a border around a range of cells.

Remarks

This is just a shortcut for calling SetCellFormat(Int32, Int32, Int32, Int32, TFlxFormat, TFlxApplyFormat, Boolean)

Syntax

Namespace: FlexCel.Core

public void DrawBorders(Int32 row1, Int32 col1, Int32 row2, Int32 col2, TFlxBorderStyle borderStyle, TExcelColor borderColor, Boolean exteriorBorders)

Parameters

<-> Parameter Type Description
row1 Int32 Row index of the top cell on the range (1 based)
col1 Int32 Column index of the left cell on the range (1 based)
row2 Int32 Row index of the bottom cell on the range (1 based)
col2 Int32 Column index of the right cell on the range (1 based)
borderStyle TFlxBorderStyle Style of the border to draw.
borderColor TExcelColor Color of the border to draw.
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.

See also