按坐标或 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');
请参阅