How to Create Hyperlink

// Import the IronXL library for Excel functionality.
using IronXL;

// Create a new workbook with the Excel file format specified as XLSX.
// The 'WorkBook.Create' method initializes a new instance of a workbook.
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Access the default worksheet in the newly created workbook.
// The default worksheet is a starting point to enter and modify data.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the value of cell A1 to a description or text.
// The text here serves as an anchor for the hyperlink.
workSheet["A1"].Value = "Link to ironpdf.com";

// Set a hyperlink on cell A1 to direct to the URL "https://ironpdf.com/".
// Hyperlinks in Excel link the text in a cell to an external web page.
workSheet.GetCellAt("A1").Hyperlink = new Hyperlink("https://ironpdf.com/");

// Save the workbook with the specified file name.
// This writes the data to the file system, making sure your Excel file is saved.
workBook.SaveAs("setLinkHyperlink.xlsx");

' Import the IronXL library for Excel functionality.

Imports IronXL



' Create a new workbook with the Excel file format specified as XLSX.

' The 'WorkBook.Create' method initializes a new instance of a workbook.

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Access the default worksheet in the newly created workbook.

' The default worksheet is a starting point to enter and modify data.

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set the value of cell A1 to a description or text.

' The text here serves as an anchor for the hyperlink.

Private workSheet("A1").Value = "Link to ironpdf.com"



' Set a hyperlink on cell A1 to direct to the URL "https://ironpdf.com/".

' Hyperlinks in Excel link the text in a cell to an external web page.

workSheet.GetCellAt("A1").Hyperlink = New Hyperlink("https://ironpdf.com/")



' Save the workbook with the specified file name.

' This writes the data to the file system, making sure your Excel file is saved.

workBook.SaveAs("setLinkHyperlink.xlsx")

using IronXL;
using System.Linq;

// Create a new workbook using the IronXL library
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Add two worksheets to the workbook
WorkSheet workSheet1 = workBook.CreateWorkSheet("Sheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("Sheet2");

// Create a global define name "Iron" at cell D5 in Sheet1.
// The `true` parameter specifies that the name is global.
workSheet1["D5"].SaveAsNamedRange("Iron", true);

// Create a worksheet-specific defined name "Hello" at cell D10 in Sheet2.
// The `false` parameter specifies that the name is local to the sheet.
workSheet2["D10"].SaveAsNamedRange("Hello", false);

// --== Within the same worksheet ==--
// Set a hyperlink in cell A1 to cell Z20 within the same worksheet (Sheet1).
workSheet1["A1"].Value = "Go to Z20";
workSheet1["A1"].Hyperlink = "Z20";

// Set a hyperlink in cell A2 to the defined name "Iron" within Sheet1.
workSheet1["A2"].Value = "Go to Iron";
workSheet1["A2"].Hyperlink = "Iron";

// --== Across worksheets ==--
// Set a hyperlink in cell A3 to cell A1 of Sheet2 from Sheet1.
workSheet1["A3"].Value = "Go to A1 of Sheet2";
workSheet1["A3"].Hyperlink = "Sheet2!A1";

// Set a hyperlink in cell A4 to the defined name "Hello" on Sheet2 from Sheet1.
workSheet1["A4"].Value = "Go to Defined name Hello of Sheet2";
workSheet1["A4"].Hyperlink = "Sheet2!Hello";

// Save the workbook to a file named "setHyperlinkAcrossWorksheet.xlsx".
workBook.SaveAs("setHyperlinkAcrossWorksheet.xlsx");

Imports IronXL

Imports System.Linq



' Create a new workbook using the IronXL library

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Add two worksheets to the workbook

Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("Sheet1")

Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("Sheet2")



' Create a global define name "Iron" at cell D5 in Sheet1.

' The `true` parameter specifies that the name is global.

workSheet1("D5").SaveAsNamedRange("Iron", True)



' Create a worksheet-specific defined name "Hello" at cell D10 in Sheet2.

' The `false` parameter specifies that the name is local to the sheet.

workSheet2("D10").SaveAsNamedRange("Hello", False)



' --== Within the same worksheet ==--

' Set a hyperlink in cell A1 to cell Z20 within the same worksheet (Sheet1).

workSheet1("A1").Value = "Go to Z20"

workSheet1("A1").Hyperlink = "Z20"



' Set a hyperlink in cell A2 to the defined name "Iron" within Sheet1.

workSheet1("A2").Value = "Go to Iron"

workSheet1("A2").Hyperlink = "Iron"



' --== Across worksheets ==--

' Set a hyperlink in cell A3 to cell A1 of Sheet2 from Sheet1.

workSheet1("A3").Value = "Go to A1 of Sheet2"

workSheet1("A3").Hyperlink = "Sheet2!A1"



' Set a hyperlink in cell A4 to the defined name "Hello" on Sheet2 from Sheet1.

workSheet1("A4").Value = "Go to Defined name Hello of Sheet2"

workSheet1("A4").Hyperlink = "Sheet2!Hello"



' Save the workbook to a file named "setHyperlinkAcrossWorksheet.xlsx".

workBook.SaveAs("setHyperlinkAcrossWorksheet.xlsx")

using IronXL; // Import IronXL to work with Excel files
using System.Linq; // Import Linq for potential enumerable operations

// Create a new workbook with an XLSX file format
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Get the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set a hyperlink in cell A1 to open a file named sample.xlsx using the FTP protocol
workSheet["A1"].Value = "Open sample.xlsx via FTP";
workSheet["A1"].Hyperlink = "ftp://C:/Users/sample.xlsx";

// Set a hyperlink in cell A2 to open a file named sample.xlsx using the local file protocol
workSheet["A2"].Value = "Open sample.xlsx from Local File";
workSheet["A2"].Hyperlink = "file:///C:/Users/sample.xlsx";

// Set a hyperlink in cell A3 to send an email to example@gmail.com
workSheet["A3"].Value = "Email example@gmail.com";
workSheet["A3"].Hyperlink = "mailto:example@gmail.com";

// Save the workbook to a file named setOtherHyperlink.xlsx
workBook.SaveAs("setOtherHyperlink.xlsx");

Imports IronXL ' Import IronXL to work with Excel files

Imports System.Linq ' Import Linq for potential enumerable operations



' Create a new workbook with an XLSX file format

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Get the default worksheet from the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set a hyperlink in cell A1 to open a file named sample.xlsx using the FTP protocol

Private workSheet("A1").Value = "Open sample.xlsx via FTP"

Private workSheet("A1").Hyperlink = "ftp://C:/Users/sample.xlsx"



' Set a hyperlink in cell A2 to open a file named sample.xlsx using the local file protocol

Private workSheet("A2").Value = "Open sample.xlsx from Local File"

Private workSheet("A2").Hyperlink = "file:///C:/Users/sample.xlsx"



' Set a hyperlink in cell A3 to send an email to example@gmail.com

Private workSheet("A3").Value = "Email example@gmail.com"

Private workSheet("A3").Hyperlink = "mailto:example@gmail.com"



' Save the workbook to a file named setOtherHyperlink.xlsx

workBook.SaveAs("setOtherHyperlink.xlsx")

using IronXL; // Import the IronXL namespace for spreadsheet manipulation

// Load an existing workbook.
// It's important that the file "setLinkHyperlink.xlsx" exists in the current working directory.
WorkBook workBook = WorkBook.Load("setLinkHyperlink.xlsx");

// Access the default worksheet from the workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Ensure we get a reference to cell A1 and remove any hyperlinks if present.
// The IronXL API provides direct access to cells, so you can modify properties directly.
workSheet["A1"].RemoveHyperlink();

// Save the workbook to a new file named "removeHyperlink.xlsx".
// This operation will create and store the workbook with the changes made.
workBook.SaveAs("removeHyperlink.xlsx");

Imports IronXL ' Import the IronXL namespace for spreadsheet manipulation



' Load an existing workbook.

' It's important that the file "setLinkHyperlink.xlsx" exists in the current working directory.

Private workBook As WorkBook = WorkBook.Load("setLinkHyperlink.xlsx")



' Access the default worksheet from the workbook.

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Ensure we get a reference to cell A1 and remove any hyperlinks if present.

' The IronXL API provides direct access to cells, so you can modify properties directly.

workSheet("A1").RemoveHyperlink()



' Save the workbook to a new file named "removeHyperlink.xlsx".

' This operation will create and store the workbook with the changes made.

workBook.SaveAs("removeHyperlink.xlsx")