Add 方法
語法
| Anchor |
必要的 IXLSRange。Range 物件。超連結的錨點 |
| Address |
必要的 WideString。超連結的位址 |
| SubAddress |
選用 WideString。超連結的子位址 |
| ScreenTip |
Optional WideString. screen tip 到 be displayed 當 mouse pointer 是 paused over hyperlink |
| TextToDisplay |
選用 WideString。要顯示為超連結的文字 |
範例
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B2', 'B2'], 'https://www.loslab.com/HotXLS.html');
end;
此範例將範圍超連結加入 B3 儲存格
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B3', 'B3'], '', 'Sheet2!A2:F10', 'Click here to view details...', 'Details');
end;
此範例將檔案超連結加入 B4 儲存格
With Workbook.Sheets[1] do
begin
Hyperlinks.Add(Range['B4', 'B4'], 'C:\Docs\readme.txt', '', 'Click here to view instruction...', 'Instruction');
end;