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

In This Topic
    Hyperlink Property (DDCell)
    In This Topic
    Sets or returns a hyperlink for the cell that will automatically be launched by Excel when it is clicked.
    Syntax
    'Declaration
     
    Public Property Hyperlink As String
    public string Hyperlink {get; set;}

    Property Value

    String.
    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