Adding a Hyperlink to a cell in an Excel file

This topic shows you how to add a hyperlink to a cell in a Microsoft® Excel™ file using the WorksheetCell object’s applyFormula function. The following code creates an Excel file with a hyperlink in cell 0 of the worksheet by using the Microsoft Excel HYPERLINK formula.

In JavaScript:

// Create a Workbook
var w = new $.ig.excel.Workbook();

// Add a new worksheet to the Workbook
var ws = w.worksheets().add("New");

// Create Hyperlink in a Worksheet cell
ws.rows(0).cells(0).applyFormula("=HYPERLINK(\"http://www.infragistics.com\",\"Infragistics\")");