Add 方法
语法
| Anchor |
必选 IXLSRange。一个 Range 对象。超链接的锚点 |
| Address |
必选 WideString。超链接的地址 |
| SubAddress |
可选 WideString。超链接的子地址 |
| ScreenTip |
可选 WideString。当鼠标指针悬停在超链接上时显示的屏幕提示 |
| TextToDisplay |
可选 WideString。为超链接显示的文本 |
示例
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B2', 'B2'], 'https://www.loslab.com/HotXLS.html');
end;
本示例 adds a range hyperlink to cell B3
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B3', 'B3'], '', 'Sheet2!A2:F10', 'Click here to view details...', 'Details');
end;
本示例 adds a file hyperlink to cell B4
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B4', 'B4'], 'C:\Docs\readme.txt', '', 'Click here to view instruction...', 'Instruction');
end;