Hyperlink in Excel Worksheet

24 Jul 202624 minutes to read

Create Hyperlink

Hyperlinks can be created in a workbook to provide quick access to web pages, locations within the workbook, and external files. A hyperlink can target any of the following targets through the ExcelHyperLinkType enum:

• Worksheet range (Workbook)
• Web URL (Url)
• E-mail (Url with mailto: prefix)
• External files (File or Unc)

Website URL Hyperlink

C# [Cross-platform]

//Creating a Hyperlink for a Website
IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.Address = "http://www.syncfusion.com";
hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link.";

C# [Windows-specific]

//Creating a Hyperlink for a Website
IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.Address = "http://www.syncfusion.com";
hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link.";

VB.NET [Windows-specific]

'Creating a Hyperlink for a Website
Dim hyperlink As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C5"))
hyperlink.Type = ExcelHyperLinkType.Url
hyperlink.Address = "http://www.Syncfusion.com"
hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link."

E-mail Hyperlink

Use the Url hyperlink type with a mailto: prefix to create an e-mail hyperlink. The address must follow the mailto:user@domain format.

C# [Cross-platform]

//Creating a Hyperlink for e-mail
IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
hyperlink1.Type = ExcelHyperLinkType.Url;
hyperlink1.Address = "mailto:[email protected]";
hyperlink1.ScreenTip = "Send Mail";

C# [Windows-specific]

//Creating a Hyperlink for e-mail
IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
hyperlink1.Type = ExcelHyperLinkType.Url;
hyperlink1.Address = "mailto:[email protected]";
hyperlink1.ScreenTip = "Send Mail";

VB.NET [Windows-specific]

'Creating a Hyperlink for e-mail
Dim hyperlink1 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C7"))
hyperlink1.Type = ExcelHyperLinkType.Url
hyperlink1.Address = "mailto:[email protected]"
hyperlink1.ScreenTip = "Send Mail"

File Opening Hyperlink

Use the File hyperlink type to open a file at a local path. The Address must be a fully qualified file path. Use the Unc type for files on a network share (Universal Naming Convention path, e.g., \\server\share\folder).

C# [Cross-platform]

//Creating a Hyperlink for Opening Files using type as File
IHyperLink hyperlink2 = sheet.HyperLinks.Add(sheet.Range["C9"]);
hyperlink2.Type = ExcelHyperLinkType.File;
hyperlink2.Address = "C:/Program files";
hyperlink2.ScreenTip = "File path";
hyperlink2.TextToDisplay = "Hyperlink for files using File as type";

C# [Windows-specific]

//Creating a Hyperlink for Opening Files using type as File
IHyperLink hyperlink2 = sheet.HyperLinks.Add(sheet.Range["C9"]);
hyperlink2.Type = ExcelHyperLinkType.File;
hyperlink2.Address = "C:/Program files";
hyperlink2.ScreenTip = "File path";
hyperlink2.TextToDisplay = "Hyperlink for files using File as type";

VB.NET [Windows-specific]

'Creating a Hyperlink for Opening Files using type as File
Dim hyperlink2 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C9"))
hyperlink2.Type = ExcelHyperLinkType.File
hyperlink2.Address = "C:/Program files"
hyperlink2.ScreenTip = "File path"
hyperlink2.TextToDisplay = "Hyperlink for files using File as type"

File Opening Hyperlink with Unc

Use the Unc hyperlink type for files on a network share, with the address in Universal Naming Convention format (e.g., \\server\share\folder).

C# [Cross-platform]

//Creating a Hyperlink for Opening Files using type as Unc
IHyperLink hyperlink3 = sheet.HyperLinks.Add(sheet.Range["C11"]);
hyperlink3.Type = ExcelHyperLinkType.Unc;
hyperlink3.Address = "C:/Documents and Settings";
hyperlink3.ScreenTip = "Click here for files";
hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type";

C# [Windows-specific]

//Creating a Hyperlink for Opening Files using type as Unc
IHyperLink hyperlink3 = sheet.HyperLinks.Add(sheet.Range["C11"]);
hyperlink3.Type = ExcelHyperLinkType.Unc;
hyperlink3.Address = "C:/Documents and Settings";
hyperlink3.ScreenTip = "Click here for files";
hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type";

VB.NET [Windows-specific]

'Creating a Hyperlink for Opening Files using type as Unc
Dim hyperlink3 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C11"))
hyperlink3.Type = ExcelHyperLinkType.Unc
hyperlink3.Address = "C:/Documents and Settings"
hyperlink3.ScreenTip = "Click here for files"
hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type"

Worksheet Cell Hyperlink

Use the Workbook hyperlink type to navigate to a cell or range within the workbook. The Address must follow the SheetName!CellAddress format (for example, Sheet1!A15); to target a different workbook, use '[FileName.xlsx]SheetName!CellAddress'.

C# [Cross-platform]

//Creating a Hyperlink to another cell using type as Workbook
IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C13"]);
hyperlink4.Type = ExcelHyperLinkType.Workbook;
hyperlink4.Address = "Sheet1!A15";
hyperlink4.ScreenTip = "Click here";
hyperlink4.TextToDisplay = "Hyperlink to cell A15";

C# [Windows-specific]

//Creating a Hyperlink to another cell using type as Workbook
IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C13"]);
hyperlink4.Type = ExcelHyperLinkType.Workbook;
hyperlink4.Address = "Sheet1!A15";
hyperlink4.ScreenTip = "Click here";
hyperlink4.TextToDisplay = "Hyperlink to cell A15";

VB.NET [Windows-specific]

'Creating a Hyperlink to another cell using type as Workbook
Dim hyperlink4 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C13"))
hyperlink4.Type = ExcelHyperLinkType.Workbook
hyperlink4.Address = "Sheet1!A15"
hyperlink4.ScreenTip = "Click here"
hyperlink4.TextToDisplay = "Hyperlink to cell A15"

The complete code example illustrating the above options is shown below.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Create(1);
	IWorksheet sheet = workbook.Worksheets[0];

	#region Hyperlinks
	//Creating a Hyperlink for a Website
	IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
	hyperlink.Type = ExcelHyperLinkType.Url;
	hyperlink.Address = "http://www.syncfusion.com";
	hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link.";

	//Creating a Hyperlink for e-mail
	IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
	hyperlink1.Type = ExcelHyperLinkType.Url;
	hyperlink1.Address = "mailto:[email protected]";
	hyperlink1.ScreenTip = "Send Mail";

	//Creating a Hyperlink for Opening Files using type as File
	IHyperLink hyperlink2 = sheet.HyperLinks.Add(sheet.Range["C9"]);
	hyperlink2.Type = ExcelHyperLinkType.File;
	hyperlink2.Address = "C:/Program files";
	hyperlink2.ScreenTip = "File path";
	hyperlink2.TextToDisplay = "Hyperlink for files using File as type";

	//Creating a Hyperlink for Opening Files using type as Unc
	IHyperLink hyperlink3 = sheet.HyperLinks.Add(sheet.Range["C11"]);
	hyperlink3.Type = ExcelHyperLinkType.Unc;
	hyperlink3.Address = "C:/Documents and Settings";
	hyperlink3.ScreenTip = "Click here for files";
	hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type";

	//Creating a Hyperlink to another cell using type as Workbook
	IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C13"]);
	hyperlink4.Type = ExcelHyperLinkType.Workbook;
	hyperlink4.Address = "Sheet1!A15";
	hyperlink4.ScreenTip = "Click here";
	hyperlink4.TextToDisplay = "Hyperlink to cell A15";
	#endregion

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/Hyperlinks.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Create(1);
  IWorksheet sheet = workbook.Worksheets[0];

  //Creating a Hyperlink for a Website
  IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range["C5"]);
  hyperlink.Type = ExcelHyperLinkType.Url;
  hyperlink.Address = "http://www.syncfusion.com";
  hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link.";

  //Creating a Hyperlink for e-mail
  IHyperLink hyperlink1 = sheet.HyperLinks.Add(sheet.Range["C7"]);
  hyperlink1.Type = ExcelHyperLinkType.Url;
  hyperlink1.Address = "mailto:[email protected]";
  hyperlink1.ScreenTip = "Send Mail";

  //Creating a Hyperlink for Opening Files using type as File
  IHyperLink hyperlink2 = sheet.HyperLinks.Add(sheet.Range["C9"]);
  hyperlink2.Type = ExcelHyperLinkType.File;
  hyperlink2.Address = "C:/Program files";
  hyperlink2.ScreenTip = "File path";
  hyperlink2.TextToDisplay = "Hyperlink for files using File as type";

  //Creating a Hyperlink for Opening Files using type as Unc
  IHyperLink hyperlink3 = sheet.HyperLinks.Add(sheet.Range["C11"]);
  hyperlink3.Type = ExcelHyperLinkType.Unc;
  hyperlink3.Address = "C:/Documents and Settings";
  hyperlink3.ScreenTip = "Click here for files";
  hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type";

  //Creating a Hyperlink to another cell using type as Workbook
  IHyperLink hyperlink4 = sheet.HyperLinks.Add(sheet.Range["C13"]);
  hyperlink4.Type = ExcelHyperLinkType.Workbook;
  hyperlink4.Address = "Sheet1!A15";
  hyperlink4.ScreenTip = "Click here";
  hyperlink4.TextToDisplay = "Hyperlink to cell A15";

  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Create(1)
  Dim sheet As IWorksheet = workbook.Worksheets(0)

  'Creating a Hyperlink for a Website
  Dim hyperlink As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C5"))
  hyperlink.Type = ExcelHyperLinkType.Url
  hyperlink.Address = "http://www.Syncfusion.com"
  hyperlink.ScreenTip = "To know more about Syncfusion products, go through this link."

  'Creating a Hyperlink for e-mail
  Dim hyperlink1 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C7"))
  hyperlink1.Type = ExcelHyperLinkType.Url
  hyperlink1.Address = "mailto:[email protected]"
  hyperlink1.ScreenTip = "Send Mail"

  'Creating a Hyperlink for Opening Files using type as File
  Dim hyperlink2 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C9"))
  hyperlink2.Type = ExcelHyperLinkType.File
  hyperlink2.Address = "C:/Program files"
  hyperlink2.ScreenTip = "File path"
  hyperlink2.TextToDisplay = "Hyperlink for files using File as type"

  'Creating a Hyperlink for Opening Files using type as Unc
  Dim hyperlink3 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C11"))
  hyperlink3.Type = ExcelHyperLinkType.Unc
  hyperlink3.Address = "C:/Documents and Settings"
  hyperlink3.ScreenTip = "Click here for files"
  hyperlink3.TextToDisplay = "Hyperlink for files using Unc as type"

  'Creating a Hyperlink to another cell using type as Workbook
  Dim hyperlink4 As IHyperLink = sheet.HyperLinks.Add(sheet.Range("C13"))
  hyperlink4.Type = ExcelHyperLinkType.Workbook
  hyperlink4.Address = "Sheet1!A15"
  hyperlink4.ScreenTip = "Click here"
  hyperlink4.TextToDisplay = "Hyperlink to cell A15"

  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to add hyperlinks in C# is present on this GitHub page.

Modifying Existing Hyperlink

The properties of an existing hyperlink can be modified by accessing it through the IRange instance. Use the IRange.Hyperlinks indexer to retrieve the hyperlink at a given position; the index is zero-based and applies to the first hyperlink found on that range.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/InputTemplate.xlsx"));
	IWorksheet worksheet = workbook.Worksheets[0];

	#region Modify Hyperlink
	//Modifying hyperlink’s text to display
	IHyperLink hyperlink = worksheet.Range["C5"].Hyperlinks[0];
	hyperlink.TextToDisplay = "Syncfusion";
	#endregion

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/ModifyHyperlink.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
  IWorksheet sheet = workbook.Worksheets[0];

  //Modifying hyperlink’s text to display
  IHyperLink hyperlink = sheet.Range["C5"].Hyperlinks[0];
  hyperlink.TextToDisplay = "Syncfusion";

  workbook.Version = ExcelVersion.Xlsx;
  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx")
  Dim sheet As IWorksheet = workbook.Worksheets(0)

  'Modifying hyperlink’s text to display
  Dim hyperlink As IHyperLink = sheet.Range("C5").Hyperlinks(0)
  hyperlink.TextToDisplay = "Syncfusion"

  workbook.Version = ExcelVersion.Xlsx
  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to modify existing hyperlink in C# is present on this GitHub page.

Removing Hyperlink

Similarly, a hyperlink can be removed from a cell or range by accessing it through the IRange instance. The example below removes the first hyperlink from the range C7.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/InputTemplate.xlsx"));
	IWorksheet worksheet = workbook.Worksheets[0];

	#region Remove Hyperlink
	//Removing Hyperlink from Range "C7"
	worksheet.Range["C7"].Hyperlinks.RemoveAt(0);
	#endregion

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/RemoveHyperlink.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
  IWorksheet sheet = workbook.Worksheets[0];

  //Removing Hyperlink from Range "C7"
  sheet.Range["C7"].Hyperlinks.RemoveAt(0);

  workbook.Version = ExcelVersion.Xlsx;
  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx")
  Dim sheet As IWorksheet = workbook.Worksheets(0)

  'Removing Hyperlink from Range "C7"
  sheet.Range("C7").Hyperlinks.RemoveAt(0)

  workbook.Version = ExcelVersion.Xlsx
  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to remove existing hyperlink in C# is present on this GitHub page.

Hyperlinks on Shapes

Adding Hyperlinks on Shapes

A hyperlink can be added to the following shapes:

• Picture
• AutoShape
• TextBox

The following code example illustrates how to insert hyperlinks to shapes.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Create(1);
	IWorksheet worksheet = workbook.Worksheets[0];

	#region Shape Hyperlink
	//Adding hyperlink to TextBox 
	ITextBox textBox = worksheet.TextBoxes.AddTextBox(1, 1, 100, 100);
	IHyperLink hyperlink = worksheet.HyperLinks.Add((textBox as IShape), ExcelHyperLinkType.Url, "http://www.Syncfusion.com", "click here");

	//Adding hyperlink to AutoShape
	IShape autoShape = worksheet.Shapes.AddAutoShapes(AutoShapeType.Cloud, 10, 1, 100, 100);
	hyperlink = worksheet.HyperLinks.Add(autoShape, ExcelHyperLinkType.Url, "mailto:[email protected]", "Send Mail");

	//Adding hyperlink to picture
	IPictureShape picture = worksheet.Pictures.AddPictureAsLink(5, 5, 10, 7, Path.GetFullPath(@"Data/Image.png"));
	hyperlink = worksheet.HyperLinks.Add(picture);
	hyperlink.Type = ExcelHyperLinkType.Unc;
	hyperlink.Address = "C://Documents and Settings";
	hyperlink.ScreenTip = "Click here for files";
	#endregion

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/ShapeHyperlink.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");

  //Adding hyperlink to TextBox 
  IWorksheet sheet = workbook.Worksheets[0];
  ITextBox textBox = sheet.TextBoxes.AddTextBox(1, 1, 100, 100);
  IHyperLink hyperlink = sheet.HyperLinks.Add((textBox as IShape), ExcelHyperLinkType.Url, "http://www.Syncfusion.com", "click here");

  //Adding hyperlink to AutoShape
  sheet = workbook.Worksheets[1];
  IShape autoShape = sheet.Shapes.AddAutoShapes(AutoShapeType.Cloud, 1, 1, 100, 100);
  hyperlink = sheet.HyperLinks.Add(autoShape, ExcelHyperLinkType.Url, "mailto:[email protected]", "Send Mail");

  //Adding hyperlink to picture
  sheet = workbook.Worksheets[2];
  IPictureShape picture = sheet.Pictures.AddPicture("Image.png");
  hyperlink = sheet.HyperLinks.Add(picture);
  hyperlink.Type = ExcelHyperLinkType.Unc;
  hyperlink.Address = "C:/Documents and Settings";
  hyperlink.ScreenTip = "Click here for files";

  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx")

  'Text box 
  Dim sheet As IWorksheet = workbook.Worksheets(0)
  Dim textBox As ITextBox = sheet.TextBoxes.AddTextBox(1, 1, 100, 100)
  Dim hyperlink As IHyperLink = sheet.HyperLinks.Add(TryCast(textBox, IShape), ExcelHyperLinkType.Url, "http://www.Syncfusion.com", "click here")

  'AutoShapes 
  sheet = workbook.Worksheets(1)
  Dim autoShape As IShape = sheet.Shapes.AddAutoShapes(AutoShapeType.Cloud, 1, 1, 100, 100)
  hyperlink = sheet.HyperLinks.Add(autoShape, ExcelHyperLinkType.Url, "mailto:[email protected]", "Send Mail")

  'Pictures 
  sheet = workbook.Worksheets(2)
  Dim picture As IPictureShape = sheet.Pictures.AddPicture("Image.png")
  hyperlink = sheet.HyperLinks.Add(picture)
  hyperlink.Type = ExcelHyperLinkType.Unc
  hyperlink.Address = "C:/Documents and Settings"
  hyperlink.ScreenTip = "Click here for files"

  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to add hyperlink to shape in C# is present on this GitHub page.

Modifying Hyperlinks on Shapes

Properties of existing hyperlink can be modified by accessing it through IWorksheet instance or IShape instance.

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/InputTemplate.xlsx"));
	IWorksheet worksheet = workbook.Worksheets[0];

	#region Modify Shape Hyperlink
	//Modifying hyperlink’s screen tip through IWorksheet instance
	IHyperLink hyperlink = worksheet.HyperLinks[0];
	hyperlink.ScreenTip = "Syncfusion";

	//Modifying hyperlink’s screen tip through IShape instance
	hyperlink = worksheet.Shapes[1].Hyperlink;
	hyperlink.ScreenTip = "Mail Syncfusion";
	#endregion

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/ModifyShapeHyperlink.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
  IWorksheet sheet = workbook.Worksheets[0];

  //Modifying hyperlink’s screen tip through IWorksheet instance
  IHyperLink hyperlink = sheet.HyperLinks[0];
  hyperlink.ScreenTip = "Syncfusion";

  //Modifying hyperlink’s screen tip through IShape instance
  hyperlink = sheet.Shapes[0].Hyperlink;
  hyperlink.ScreenTip = "Syncfusion";

  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx")
  Dim sheet As IWorksheet = workbook.Worksheets(0)

  'Modifying hyperlink’s screen tip through IWorksheet instance
  Dim hyperlink As IHyperLink = sheet.HyperLinks(0)
  hyperlink.ScreenTip = "Syncfusion"

  'Modifying hyperlink’s screen tip through IShape instance
  hyperlink = sheet.Shapes(0).Hyperlink
  hyperlink.ScreenTip = "Syncfusion"

  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to modify shape hyperlink in C# is present on this GitHub page.

Removing Hyperlinks from Shapes

The following code snippet explains how to remove a hyperlink from a shape. To remove a shape’s hyperlink, access the shape through the IShape.Hyperlink property and call Remove on the worksheet’s hyperlink collection, or remove the hyperlink at the sheet level using worksheet.HyperLinks.RemoveAt(index) (as shown in the example).

C# [Cross-platform]

using (ExcelEngine excelEngine = new ExcelEngine())
{
	IApplication application = excelEngine.Excel;
	application.DefaultVersion = ExcelVersion.Xlsx;
	IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath("Data/InputTemplate.xlsx"));
	IWorksheet worksheet = workbook.Worksheets[0];

	//Removing hyperlink from sheet with Index
	worksheet.HyperLinks.RemoveAt(0);

	#region Save
	//Saving the workbook
	workbook.SaveAs(Path.GetFullPath("Output/RemoveShapeHyperlink.xlsx"));
	#endregion
}

C# [Windows-specific]

using (ExcelEngine excelEngine = new ExcelEngine())
{
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;
  IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");
  IWorksheet sheet = workbook.Worksheets[0];

  //Removing hyperlink from sheet with Index
  sheet.HyperLinks.RemoveAt(0);

  workbook.SaveAs("Hyperlink.xlsx");
}

VB.NET [Windows-specific]

Using excelEngine As ExcelEngine = New ExcelEngine()
  Dim application As IApplication = excelEngine.Excel
  application.DefaultVersion = ExcelVersion.Xlsx
  Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx")
  Dim sheet As IWorksheet = workbook.Worksheets(0)

  'Removing Hyperlink from sheet with Index
  sheet.HyperLinks.RemoveAt(0)

  workbook.SaveAs("Hyperlink.xlsx")
End Using

A complete working example to remove shape hyperlink in C# is present on this GitHub page.