天软金融分析.NET函数大全
>
文档处理函数
>
Excel处理函数
>
Excel操作相关的类
>
TxlsSheet类
>
TxlsSheet方法
MakeHyperlink
复制链接
简述
为指定单元格创建超链接
定义
MakeHyperlink(ACol;ARow: integer; AAddress; AText;ATooltip: String);
参数
名称
类型
说明
ACol
integer
整数,指定单元格所在列值,从0开始
ARow
integer
整数,指定单元格所在行值,从0开始
Aaddress
String
字符串,点击超链接导向的地址
Atext
String
字符串,单元格文本值
Atooltip
String
字符串,鼠标悬浮时提示文本
返回
无。
相关
AsString
AsRichText
AsFmtString
AsHyperlink
AsHTML
AsStringW
AsRichTextW
AsFmtStringW
AsHyperlinkW
AsHTMLW
AsBoolean
AsError
Value
ValueW
AsEmpty
AsFormula
AsFormulaW
AsNumFormulaValue
AsStrFormulaValue
AsStrFormulaValueW
AsBoolFormulaValue
IsDateTime
IsError
CellType
FormulaType
Protection
HorizAlignment
VertAlignment
Indent
Rotation
WrapText
ShrinkToFit
FillPatternForeColor
FillPatternBackColor
FillPatternPattern
NumberFormat
NumberFormatW
BorderTopColor
BorderTopStyle
BorderLeftColor
BorderLeftStyle
BorderRightColor
BorderRightStyle
BorderBottomColor
BorderBottomStyle
BorderDiagColor
BorderDiagStyle
FontName
FontNameW
FontFamily
FontColor
FontSize
FontStyle
FontSubSuperScript
FontUnderline
FillPatternForeColorRGB
FillPatternBackColorRGB
BorderTopColorRGB
BorderLeftColorRGB
BorderRightColorRGB
BorderBottomColorRGB
BorderDiagColorRGB
CellColorRGB
Values
ValuesW
AsBlank
AsInteger
AsFloat
AsDateTime
Comment
CommentW
RowHeight
RowHide
ColWidth
ColHide
MergedCells
HasComment
DeleteComment
MergeCells
UnMergeCells
Clear
AutoWidthCol
AutoHeightRow
UnfreezePanes
FreezePanes
UnsplitPanes
SplitPanes
Calculate
CalculateW
CopyCell
CopyCells
DeleteCell
DeleteCells
MoveCell
MoveCells
DeleteRows
ClearRows
InsertRows
CopyRows
MoveRows
DeleteColumns
ClearColumns
InsertColumns
CopyColumns
MoveColumns
IsEmpty
Sort
GroupRows
GroupColumns
UngroupRows
UngroupColumns
FindCell
MakeHyperlink
CalcDimensionsEx
FirstCol
LastCol
FirstRow
LastRow
SetDefaultFormat
IsFormatted