Add Hyperlinks in Excel
22 Dec 20224 minutes to read
A hyperlink is a reference to a specific location, document, or webpage that the user can jump to by clicking the link in a cell. Hyperlinks are easily recognizable because this is a text highlighted with underlined blue color.
The following code shows how to add hyperlinks in Excel with Interop and XlsIO for .NET.
Interop
private void AddHyperlinks()
{
//Instantiate the application object
var excelApp = new Microsoft.Office.Interop.Excel.Application();
//Add a workbook
Workbook workbook = excelApp.Workbooks.Add(System.Reflection.Missing.Value);
//Get the first sheet
Worksheet worksheet = (Worksheet)workbook.Sheets["Sheet1"];
//Define a range object (A1)
Range range;
range = worksheet.get_Range("A1", "A1");
//Add a hyperlink to it
worksheet.Hyperlinks.Add(range, "https://www.syncfusion.com/", Type.Missing, "Click to go to Syncfusion site", "Syncfusion Site!");
//Save the file
workbook.SaveCopyAs("InteropOutput_Hyperlinks.xlsx");
//Quit the application
excelApp.Quit();
}
Private Sub AddHyperlinks()
'Instantiate the application object
Dim excelApp = New Microsoft.Office.Interop.Excel.Application()
'Add a workbook
Dim workbook As Workbook = excelApp.Workbooks.Add(System.Reflection.Missing.Value)
'Get the first sheet
Dim worksheet As Worksheet = workbook.Sheets("Sheet1")
'Define a range object (A1)
Dim range As Range
range = worksheet.Range("A1", "A1")
'Add a hyperlink to it
worksheet.Hyperlinks.Add(range, "https://www.syncfusion.com/", Type.Missing, "Click to go to Syncfusion site", "Syncfusion Site!")
'Save the file
workbook.SaveCopyAs("InteropOutput_Hyperlinks.xlsx")
'Quit the application
excelApp.Quit()
End Sub
XlsIO
private void AddHyperlinks()
{
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Instantiate the application object
IApplication application = excelEngine.Excel;
//Create a workbook
IWorkbook workbook = application.Workbooks.Create(1);
//Get the first sheet
IWorksheet worksheet = workbook.Worksheets[0];
//Create a hyperlink for a website
IHyperLink hyperlink = worksheet.HyperLinks.Add(worksheet.Range["A1"]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.Address = "http://www.syncfusion.com";
hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link.";
hyperlink.TextToDisplay = "Syncfusion Site!";
//Save the workbook
workbook.SaveAs(@"XlsIOOutput_Hyperlinks.xlsx");
}
}
Private Sub AddHyperlinks()
Using excelEngine As ExcelEngine = New ExcelEngine()
'Instantiate the application object
Dim application As IApplication = excelEngine.Excel
'Create a workbook
Dim workbook As IWorkbook = application.Workbooks.Create(1)
'Get the first sheet
Dim worksheet As IWorksheet = workbook.Worksheets(0)
'Create a hyperlink for a website
Dim hyperlink As IHyperLink = worksheet.HyperLinks.Add(worksheet.Range("A1"))
hyperlink.Type = ExcelHyperLinkType.Url
hyperlink.Address = "http://www.syncfusion.com"
hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link."
hyperlink.TextToDisplay = "Syncfusion Site!"
'Save as Excel file
workbook.SaveAs("XlsIOOutput_Hyperlinks.xlsx")
End Using
End Sub