Sets or returns a hyperlink for the cell that will automatically be launched by Excel when it is clicked.

Syntax

Visual Basic (Declaration)
Public Property Hyperlink As String

Visual Basic (Usage)	Copy Code
`Dim instance As DDCell Dim value As String instance.Hyperlink = value value = instance.Hyperlink`

C#
public string Hyperlink {get; set;}

Return Value

String.

Example

C# Copy Code

C#	Copy Code
sb.Sheets[0].Cell(0,0).Alignment = DataDynamics.SpreadBuilder.Style.HorzAlignments.Right; sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderBottomStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both; sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair; sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderLeftStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderRightStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderTopStyle = DataDynamics.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 = DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single; sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue; sb.Sheets[0].Cell(0,0).Hyperlink = "www.datadynamics.com"; sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥; sb.Sheets[0].Cell(0,0).TextAngle = 255; sb.Sheets[0].Cell(0,0).VertAlignment = DataDynamics.SpreadBuilder.Style.VertAlignments.Top; sb.Sheets[0].Cell(0,0).WrapText = true;

sb.Sheets[0].Cell(0,0).Alignment =
DataDynamics.SpreadBuilder.Style.HorzAlignments.Right;

sb.Sheets[0].Cell(0,0).BorderBottomColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderBottomStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderDiagonalColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderDiagonalEnum =
DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both;

sb.Sheets[0].Cell(0,0).BorderDiagonalStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair;

sb.Sheets[0].Cell(0,0).BorderLeftColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderLeftStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderRightColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderRightStyle =
DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double;

sb.Sheets[0].Cell(0,0).BorderTopColor =
System.Drawing.Color.Red;

sb.Sheets[0].Cell(0,0).BorderTopStyle =
DataDynamics.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 =
DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single;

sb.Sheets[0].Cell(0,0).ForeColor =
System.Drawing.Color.Blue;

sb.Sheets[0].Cell(0,0).Hyperlink =
"www.datadynamics.com";

sb.Sheets[0].Cell(0,0).NumberFormat =
"[$¥;

sb.Sheets[0].Cell(0,0).TextAngle = 255;

sb.Sheets[0].Cell(0,0).VertAlignment =
DataDynamics.SpreadBuilder.Style.VertAlignments.Top;

sb.Sheets[0].Cell(0,0).WrapText =
true;

Visual Basic Copy Code

Visual Basic	Copy Code
With sb.Sheets(0).Cell(0, 0) .Alignment = DataDynamics.SpreadBuilder.Style.HorzAlignments.Right .BorderBottomColor = System.Drawing.Color.Red .BorderBottomStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double .BorderDiagonalColor = System.Drawing.Color.Red .BorderDiagonalEnum = DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both .BorderDiagonalStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair .BorderLeftColor = System.Drawing.Color.Red .BorderLeftStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double .BorderRightColor = System.Drawing.Color.Red .BorderRightStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double .BorderTopColor = System.Drawing.Color.Red .BorderTopStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double .FillColor = System.Drawing.Color.Gray .FontBold = True .FontItalic = True .FontName = "Times New Roman" .FontSize = 14 .FontUnderlineStyle = DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single .ForeColor = System.Drawing.Color.Blue .Hyperlink = "www.datadynamics.com" .NumberFormat = "[$¥-0]#,##0.00" .TextAngle = 255 .VertAlignment = DataDynamics.SpreadBuilder.Style.VertAlignments.Top .WrapText = True End With

With sb.Sheets(0).Cell(0, 0)

    .Alignment = DataDynamics.SpreadBuilder.Style.HorzAlignments.Right

    .BorderBottomColor = System.Drawing.Color.Red

    .BorderBottomStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double

    .BorderDiagonalColor = System.Drawing.Color.Red

    .BorderDiagonalEnum = DataDynamics.SpreadBuilder.Style.BorderDiagonalStyles.Both

    .BorderDiagonalStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Hair

    .BorderLeftColor = System.Drawing.Color.Red

    .BorderLeftStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double

    .BorderRightColor = System.Drawing.Color.Red

    .BorderRightStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double

    .BorderTopColor = System.Drawing.Color.Red

    .BorderTopStyle = DataDynamics.SpreadBuilder.Style.BorderLineStyle.Double

    .FillColor = System.Drawing.Color.Gray

    .FontBold = True

    .FontItalic = True

    .FontName = "Times New Roman"

    .FontSize = 14

    .FontUnderlineStyle = DataDynamics.SpreadBuilder.Style.FontUnderlineStyles.Single

    .ForeColor = System.Drawing.Color.Blue

    .Hyperlink = "www.datadynamics.com"

    .NumberFormat = "[$¥-0]#,##0.00"

    .TextAngle = 255

    .VertAlignment = DataDynamics.SpreadBuilder.Style.VertAlignments.Top

    .WrapText = True

End With

ActiveReports.XlsExport	Request technical support
Hyperlink Property
See Also Example

Syntax

Return Value

Example

See Also

Reference