新增 hyperlink 到 一個 工作表 儲存格 透過 coordinates 或 A1-樣式 參考 和 writes display 文字 到 儲存格
語法
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-基於 工作表 coordinates 的 target 儲存格 |
| ARange |
A1-樣式 target 儲存格 參考 |
| Address |
URL, 檔案 address, 或 活頁簿 target 用於 hyperlink |
| TextToDisplay |
文字 written 到 target 儲存格 和 stored as hyperlink display 文字. If omitted 或 empty, address 是 已使用 |
| ScreenTip |
Optional tooltip shown 透過 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');
另請參閱