GrapeCity.Documents.Excel.BordersIndex

BordersIndex Enum

Specifies which border of a cell or range to retrieve.

Use this enum with this[BordersIndex] to access a specific edge, inside border, or diagonal border of a range and apply individual border settings.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum BordersIndex

Public Enum BordersIndex

Examples

IRange range = worksheet.Range["B2:C3"];
range.Borders.LineStyle = BorderLineStyle.Thin;
range.Borders[BordersIndex.InsideHorizontal].LineStyle = BorderLineStyle.Double;
range.Borders[BordersIndex.EdgeBottom].Color = Color.Blue;

Fields

Name	Description
DiagonalDown	Specifies that the border runs from the upper left-hand corner to the lower right of each cell in the range.
DiagonalUp	Specifies that the border runs from the lower left-hand corner to the upper right of each cell in the range.
EdgeBottom	Specifies the border is at the bottom of the range.
EdgeLeft	Specifies that the border is at the left-hand edge of the range.
EdgeRight	Specifies that the border is at the right-hand edge of the range.
EdgeTop	Specifies that the border is at the top of the range.
InsideHorizontal	Specifies that there are horizontal borders for all cells in the range except borders on the outside of the range.
InsideVertical	Specifies that there are vertical borders for all the cells in the range except borders on the outside of the range.