Hyperlink プロパティ (DDCell)

セルをクリックしたときに、Excelが自動的に立ち上げるセルのハイパーリンクを設定または取得します。

シンタックス

Visual Basic
C#

'宣言
 
Public Property Hyperlink As String

public string Hyperlink {get; set;}

プロパティ値

文字列型。

使用例

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;

Visual Basic

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

参照

DDCell クラス
 DDCell メンバ