Version

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 method. The following code creates an Excel file with a hyperlink in cell 0 of the worksheet by using the intrinsic Excel HYPERLINK formula.

Before you start writing any code, you should place using/imports directives in your code-behind so you don’t need to always type out a member’s fully qualified name.

In Visual Basic:

Imports Infragistics.Documents.Excel

In C#:

using Infragistics.Documents.Excel;

In Visual Basic:

'Create an Excel File
 Dim s As String = "C:\theFile.xls"
 'Create a Workbook
 Dim w As New Workbook()
 'Add a new worksheet to the Workbook
 Dim ws As Worksheet = w.Worksheets.Add("New")
 'Create Hyperlink in a Worksheet cell
ws.Rows(0).Cells(0).ApplyFormula("=HYPERLINK(""http://es.infragistics.com"",""Infragistics"")")
 w.Save(s)

In C#:

//Create an Excel File
 string s = @" C:\theFile.xls";
//Create a Workbook
 Workbook w = new Workbook();
//Add a new worksheet to the Workbook
Worksheet ws = w.Worksheets.Add("New");
 //Create Hyperlink in a Worksheet cell
ws.Rows[0].Cells[0].ApplyFormula(@"=HYPERLINK(""http://es.infragistics.com"",""Infragistics"")");
 w.Save(s);

Result:

Displays the result of using the code listed above.