Documentación HotXLS

método AddHyperlink

agrega hyperlink uno hoja de cálculo celda por coordinates o A1-estilo referencia y writes display texto que celda

Sintaxis

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;
    

Parámetros

Row, Col 1-basado hoja de cálculo coordinates de target celda
ARange A1-estilo target celda referencia
Address URL, archivo address, o libro target para hyperlink
TextToDisplay texto written target celda y stored as hyperlink display texto. If omitted o empty, address es usado
ScreenTip Optional tooltip shown por spreadsheet applications

Ejemplo

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

Véase también

clase TXLSWorksheet
propiedad TXLSWorksheet.Hyperlinks
método IXLSHyperLinks.Add