ActiveReports 14 .NET Edition
GrapeCity.ActiveReports.Export.Excel Assembly / GrapeCity.SpreadBuilder.Cells Namespace / DDCell Class / BorderTopColor Property
Example

In This Topic
    BorderTopColor Property (DDCell)
    In This Topic
    Sets or returns the color of the top border.
    Syntax
    'Declaration
     
    Public Property BorderTopColor As Color
    public Color BorderTopColor {get; set;}

    Property Value

    System.Drawing.Color.
    Remarks
    This property has no effect if the BorderTopStyle property is not set.
    Example
    sb.Sheets[0].Cell(0,0).Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right;
    sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both;
    sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair;
    sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red;
    sb.Sheets[0].Cell(0,0).BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double;
    sb.Sheets[0].Cell(0,0).FillColor = System.Drawing.Color.Gray;
    sb.Sheets[0].Cell(0,0).FontBold = true;
    sb.Sheets[0].Cell(0,0).FontItalic = true;
    sb.Sheets[0].Cell(0,0).FontName = "Times New Roman";
    sb.Sheets[0].Cell(0,0).FontSize = 14;
    sb.Sheets[0].Cell(0,0).FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single;
    sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue;
    sb.Sheets[0].Cell(0,0).Hyperlink = "www.GrapeCity.com";
    sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥-0]#,##0.00";
    sb.Sheets[0].Cell(0,0).TextAngle = 255;
    sb.Sheets[0].Cell(0,0).VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top;
    sb.Sheets[0].Cell(0,0).WrapText = true;
    With sb.Sheets(0).Cell(0, 0)
        .Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right
        .BorderBottomColor = System.Drawing.Color.Red
        .BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderDiagonalColor = System.Drawing.Color.Red
        .BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both
        .BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair
        .BorderLeftColor = System.Drawing.Color.Red
        .BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderRightColor = System.Drawing.Color.Red
        .BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .BorderTopColor = System.Drawing.Color.Red
        .BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double
        .FillColor = System.Drawing.Color.Gray
        .FontBold = True
        .FontItalic = True
        .FontName = "Times New Roman"
        .FontSize = 14
        .FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single
        .ForeColor = System.Drawing.Color.Blue
        .Hyperlink = "www.GrapeCity.com"
        .NumberFormat = "[$¥-0]#,##0.00"
        .TextAngle = 255
        .VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top
        .WrapText = True
    End With
    See Also