HotXLS Docs

TXLSXBorder class

Stores the five edges of a cell border (Left, Right, Top, Bottom, Diagonal), each a TXLSXBorderEdge with its own style and color, applied through a TXLSXCellFormat brush; TXLSXBorders TXLSXBorder class for HotXLS components

Syntax

TXLSXBorder = class;
TXLSXBorderEdge = class;
TXLSXBorders = class;
    

Key members

Left, Right, Top, Bottom, DiagonalRead-only TXLSXBorderEdge for each edge
DiagonalUp, DiagonalDownBoolean; which direction(s) of the Diagonal edge are drawn (both share the Diagonal edge's Style/Color)
SetAllSets Style (and optionally Color) on all five edges in one call
TXLSXBorderEdge.Style, .ColorTXLSXBorderStyle and ARGB colour of a single edge; ColorTheme/ColorIndex/TintAndShade mirror TXLSXFont's colour-source priority (theme > indexed > RGB)
Add, Count, ItemsTXLSXBorders pool members: append a new instance, and enumerate the pool

Example

This example draws a thin black box around the cells formatted through CellFormat, then colours just the top edge red

CellFormat.Border.SetAll(xlsxBorderThin);
CellFormat.Border.Top.Color := $00FF0000;

See also

TXLSXWorkbook class
TXLSXWorkbook class