HotXLS 文档

AddHyperlink 方法

按坐标或 A1 样式引用向一个工作表单元格添加超链接,并把显示文本写入该单元格

语法

function AddHyperlink(Row, Col: Integer; Address: WideString): IXLSHyperLink; overload;
function AddHyperlink(ARange: WideString; Address: WideString): IXLSHyperLink; overload;
function AddHyperlink(Row, Col: Integer; Address: WideString; TextToDisplay: WideString): IXLSHyperLink; overload;
function AddHyperlink(ARange: WideString; Address: WideString; TextToDisplay: WideString): IXLSHyperLink; overload;
function AddHyperlink(Row, Col: Integer; Address: WideString; TextToDisplay: WideString; ScreenTip: WideString): IXLSHyperLink; overload;
function AddHyperlink(ARange: WideString; Address: WideString; TextToDisplay: WideString; ScreenTip: WideString): IXLSHyperLink; overload;
    

参数

Row, Col 1-based worksheet coordinates of the target cell
ARange A1-style target cell reference
Address URL, file address, or workbook target for the hyperlink
TextToDisplay 写入目标单元格并存储为超链接显示文本的文本。省略或为空时使用地址
ScreenTip Optional tooltip shown by spreadsheet applications

示例

Workbook.Sheets[1].AddHyperlink(
  1, 2,
  'https://www.loslab.com',
  'Visit losLab',
  'Open site');

Workbook.Sheets[1].AddHyperlink(
  'C4',
  'www.loslab.com/docs',
  'Read docs',
  'Open documentation');
    

请参阅

TXLSWorksheet class
TXLSWorksheet.Hyperlinks 属性
IXLSHyperLinks.Add 方法