Web Components Spreadsheet Hyperlinks

    The Web Components Spreadsheet component allows display of pre-existing hyperlinks in your Excel workbook as well as insertion of new ones that can link to websites, file directories, and even other worksheets in the workbook.

    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://ko.infragistics.com", "Infragistics", "Infragistics Home Page"));

    API References