HotXLS-dokumentation
Indhold
Startside
Oversigt
TXLSWorksheet
Startside
Indhold
Oversigt
AddHyperlink metode
Adds a hyperlink to one worksheet cell by coordinates or A1-style reference and writes the display text to that cell
Syntaks
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;
Parametre
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
Text written to the target cell and stored as the hyperlink display text. If omitted or empty, the address is used
ScreenTip
Optional tooltip shown by spreadsheet applications
Eksempel
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');
Se også
klasse TXLSWorksheet
TXLSWorksheet.Hyperlinksegenskab
IXLSHyperLinks.Addmetode
Copyright © 2010-2026 losLab Software