GrapeCity.Documents.Excel.IDisplayFormat.Borders

Borders Property

Borders

Gets an IBorders object that represents the borders of the associated range object as displayed in the current user interface.

Declaration

IBorders Borders { get; }

ReadOnly Property Borders As IBorders

Examples

IRange cell = worksheet.Range["A1"];
cell.Value = 1234.56;
cell.Borders[BordersIndex.EdgeBottom].LineStyle = BorderLineStyle.Thin;
IFormatCondition condition = (IFormatCondition) cell.FormatConditions.Add(
    FormatConditionType.CellValue, FormatConditionOperator.Greater, "1000", null);
condition.Interior.Color = Color.Yellow;
condition.Borders[BordersIndex.EdgeBottom].LineStyle = BorderLineStyle.Thick;
IBorders borders = cell.DisplayFormat.Borders;
IBorder bottomBorder = borders[BordersIndex.EdgeBottom];