Get Hyperlinks in Range

The Range class provides a Hyperlinks property which returns all the hyperlinks in the selected range. You may also delete the Hyperlink by calling the Hyperlink.Delete method.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string sourceDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Instantiate a Workbook object
// Open an Excel file
Workbook workbook = new Workbook(sourceDir + "HyperlinksSample.xlsx");
// Get the first (default) worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Create a range A2:B3
Range range = worksheet.Cells.CreateRange("A2", "B3");
// Get Hyperlinks in range
Hyperlink[] hyperlinks = range.Hyperlinks;
foreach (Hyperlink link in hyperlinks)
{
Console.WriteLine(link.Area + " : " + link.Address);
// To delete the link, use the Hyperlink.Delete() method.
link.Delete();
}
workbook.Save(outputDir + "HyperlinksSample_out.xlsx");