HotXLS-dokumentaatio Sisältö Etusivu Yleiskatsaus TXLSWorksheet Etusivu Sisältö Yleiskatsaus

AddHyperlink metodi

Adds a hyperlink to one worksheet cell by coordinates or A1-style reference and writes the display text to that cell

Syntaksi

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;

Parametrit

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

Esimerkki

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');

Katso myös

luokka TXLSWorksheet
TXLSWorksheet.Hyperlinksominaisuus
IXLSHyperLinks.Addmetodi Copyright © 2010-2026 losLab Software