Web Components Spreadsheet Hyperlinks

    El componente Web Components hoja de cálculo permite la visualización de hipervínculos preexistentes en el libro de Excel, así como la inserción de otros nuevos que pueden vincularse a sitios web, directorios de archivos e incluso otras hojas de cálculo en el libro.

    Hyperlinks are added to the IgcSpreadsheetComponent control by accessing the Hyperlinks collection on the worksheet that you want to place the hyperlink on. This collection has an Add method that takes a WorksheetHyperlink object, where you can define the cell address, the hyperlink URL to be navigated to, the display text, and a tooltip to optionally be displayed on hover.

    Dependencies

    When setting up your Web Components spreadsheet control to use hyperlinks, you will need to import the WorksheetHyperlink class like so:

    import { WorksheetHyperlink } from 'igniteui-webcomponents-excel';

    Code Snippet

    The following code snippet demonstrates how to add a hyperlink to the currently viewed worksheet in the Web Components IgcSpreadsheetComponent control:

    this.spreadsheet.activeWorksheet.hyperlinks().add(new WorksheetHyperlink("A1", "http://es.infragistics.com", "Infragistics", "Infragistics Home Page"));

    API References