PM> Install-Package Spire.XLS

using Spire.Xls;
using Spire.Xls.Collections;
using Spire.Xls.Core.Spreadsheet;
using System.IO;
using System.Text;

namespace ExtractHyperlinks
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("Hyperlinks1.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Get the collection of all hyperlinks in the worksheet
            HyperLinksCollection hyperLinks = sheet.HyperLinks;
           
            //Initialize an instance of the StringBuilder class
            StringBuilder sb = new StringBuilder();

            //Iterate through the hyperlinks in the collection
            foreach (XlsHyperLink hyperlink in hyperLinks)
            {
                //Get the address of the hyperlink
                string address = hyperlink.Address;
                //Get the type of the hyperlink
                HyperLinkType type = hyperlink.Type;
                //Append the address and type of the hyperlink to the StringBuilder instance
                sb.AppendLine("Link address: " + address);
                sb.AppendLine("Link type: " + type.ToString());               
                sb.AppendLine();
            }

            //Write the content of the StringBuilder instance to a text file
            File.WriteAllText("GetHyperlinks.txt", sb.ToString());
            workbook.Dispose();
        }
    }
}

Imports Spire.Xls
Imports Spire.Xls.Collections
Imports Spire.Xls.Core.Spreadsheet
Imports System.IO
Imports System.Text

Namespace ExtractHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Hyperlinks1.xlsx")

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Get the collection of all hyperlinks in the worksheet
            Dim hyperLinks As HyperLinksCollection = sheet.HyperLinks

            'Initialize an instance of the StringBuilder class
            Dim sb As StringBuilder = New StringBuilder()

            'Iterate through the hyperlinks in the collection
            For Each hyperlink As XlsHyperLink In hyperLinks
                'Get the address of the hyperlink
                Dim address As String = hyperlink.Address
                'Get the type of the hyperlink
                Dim type As HyperLinkType = hyperlink.Type
                'Append the address and type of the hyperlink to the StringBuilder instance
                sb.AppendLine("Link address: " & address)
                sb.AppendLine("Link type: " & type.ToString().ToString())
                sb.AppendLine()
            Next

            'Write the content of the StringBuilder instance to a text file
            Call File.WriteAllText("GetHyperlinks.txt", sb.ToString())
            workbook.Dispose()
        End Sub
    End Class
End Namespace

using Spire.Xls;
using Spire.Xls.Collections;
using Spire.Xls.Core.Spreadsheet;

namespace ModifyHyperlinks
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("Hyperlinks2.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Get the collection of all hyperlinks in the worksheet
            HyperLinksCollection links = sheet.HyperLinks;
            //Get the first hyperlink in the collection
            XlsHyperLink hyperLink = links[0];

            //Modify the display text and the address of the hyperlink
            hyperLink.TextToDisplay = "Spire.XLS for .NET";
            hyperLink.Address = "http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html";

            //Save the result file
            workbook.SaveToFile("ModifyHyperlink.xlsx", ExcelVersion.Version2013);
            workbook.Dispose();
        }
    }
}

Imports Spire.Xls
Imports Spire.Xls.Collections
Imports Spire.Xls.Core.Spreadsheet

Namespace ModifyHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Hyperlinks2.xlsx")

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Get the collection of all hyperlinks in the worksheet
            Dim links As HyperLinksCollection = sheet.HyperLinks
            'Get the first hyperlink in the collection
            Dim hyperLink As XlsHyperLink = links(0)

            'Modify the display text and the address of the hyperlink
            hyperLink.TextToDisplay = "Spire.XLS for .NET"
            hyperLink.Address = "http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html"

            'Save the result file
            workbook.SaveToFile("ModifyHyperlink.xlsx", ExcelVersion.Version2013)
            workbook.Dispose()
        End Sub
    End Class
End Namespace

using Spire.Xls;

namespace RemoveHyperlinks
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //Initialize an instance of the Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("Hyperlinks2.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Remove the first hyperlink and keep its display text
            sheet.HyperLinks.RemoveAt(0);

            //Remove all content from the cell
            //sheet.Range["B2"].ClearAll();

            //Save the result file
            workbook.SaveToFile("RemoveHyperlink.xlsx", ExcelVersion.Version2013);
            workbook.Dispose();
        }
    }
}

Imports Spire.Xls

Namespace RemoveHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Initialize an instance of the Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Hyperlinks2.xlsx")

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Remove the first hyperlink and keep its display text
            sheet.HyperLinks.RemoveAt(0)

            'Remove all content from the cell
            'sheet.Range["B2"].ClearAll();

            'Save the result file
            workbook.SaveToFile("RemoveHyperlink.xlsx", ExcelVersion.Version2013)
            workbook.Dispose()
        End Sub
    End Class
End Namespace

PM> Install-Package Spire.XLS

using Spire.Xls;

namespace AddTextHyperlinks
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook instance
            Workbook workbook = new Workbook();

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Add a text hyperlink that leads to a webpage
            CellRange cell1 = sheet.Range["B3"];
            HyperLink urlLink = sheet.HyperLinks.Add(cell1);
            urlLink.Type = HyperLinkType.Url;
            urlLink.TextToDisplay = "Link to a website";
            urlLink.Address = "https://www.google.com/";

            //Add a text hyperlink that leads to an email address
            CellRange cell2 = sheet.Range["E3"];
            HyperLink mailLink = sheet.HyperLinks.Add(cell2);
            mailLink.Type = HyperLinkType.Url;
            mailLink.TextToDisplay = "Link to an email address";
            mailLink.Address = "mailto:abc@outlook.com";

            //Add a text hyperlink that leads to an external file
            CellRange cell3 = sheet.Range["B7"];
            HyperLink fileLink = sheet.HyperLinks.Add(cell3);
            fileLink.Type = HyperLinkType.File;
            fileLink.TextToDisplay = "Link to an external file";
            fileLink.Address = "C:\\Users\\Administrator\\Desktop\\Report.xlsx";

            //Add a text hyperlink that leads to a cell in another sheet
            CellRange cell4 = sheet.Range["E7"];
            HyperLink linkToSheet = sheet.HyperLinks.Add(cell4);
            linkToSheet.Type = HyperLinkType.Workbook;
            linkToSheet.TextToDisplay = "Link to a cell in sheet2";
            linkToSheet.Address = "Sheet2!B5";

            //Add a text hyperlink that leads to a UNC address
            CellRange cell5 = sheet.Range["B11"];
            HyperLink uncLink = sheet.HyperLinks.Add(cell5);
            uncLink.Type = HyperLinkType.Unc;
            uncLink.TextToDisplay = "Link to a UNC address";
            uncLink.Address = "\\\\192.168.0.121";

            //Autofit column width
            sheet.AutoFitColumn(2);
            sheet.AutoFitColumn(5);

            //Save the result file
            workbook.SaveToFile("AddTextHyperlinks.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace AddTextHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook()

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Add a text hyperlink that leads to a webpage
            Dim cell1 As CellRange = sheet.Range("B3")
            Dim urlLink As HyperLink = sheet.HyperLinks.Add(cell1)
            urlLink.Type = HyperLinkType.Url
            urlLink.TextToDisplay = "Link to a website"
            urlLink.Address = "https://www.google.com/"

            'Add a text hyperlink that leads to an email address
            Dim cell2 As CellRange = sheet.Range("E3")
            Dim mailLink As HyperLink = sheet.HyperLinks.Add(cell2)
            mailLink.Type = HyperLinkType.Url
            mailLink.TextToDisplay = "Link to an email address"
            mailLink.Address = "mailto:abc@outlook.com"

            'Add a text hyperlink that leads to an external file
            Dim cell3 As CellRange = sheet.Range("B7")
            Dim fileLink As HyperLink = sheet.HyperLinks.Add(cell3)
            fileLink.Type = HyperLinkType.File
            fileLink.TextToDisplay = "Link to an external file"
            fileLink.Address = "C:\\Users\\Administrator\\Desktop\\Report.xlsx"

            'Add a text hyperlink that leads to a cell in another sheet
            Dim cell4 As CellRange = sheet.Range("E7")
            Dim linkToSheet As HyperLink = sheet.HyperLinks.Add(cell4)
            linkToSheet.Type = HyperLinkType.Workbook
            linkToSheet.TextToDisplay = "Link to a cell in sheet2"
            linkToSheet.Address = "Sheet2!B5"

            'Add a text hyperlink that leads to a UNC address
            Dim cell5 As CellRange = sheet.Range("B11")
            Dim uncLink As HyperLink = sheet.HyperLinks.Add(cell5)
            uncLink.Type = HyperLinkType.Unc
            uncLink.TextToDisplay = "Link to a UNC address"
            uncLink.Address = "\\\\192.168.0.121"

            'Autofit column width
            sheet.AutoFitColumn(2)
            sheet.AutoFitColumn(5)

            'Save the result file
            workbook.SaveToFile("AddTextHyperlinks.xlsx", ExcelVersion.Version2013)
        End Sub
    End Class
End Namespace

using Spire.Xls;

namespace AddImageHyperlinks
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook instance
            Workbook workbook = new Workbook();
            //Get the first worksheet 
            Worksheet sheet = workbook.Worksheets[0];

            //Insert an image into the worksheet
            ExcelPicture picture = sheet.Pictures.Add(5, 3, "Logo.png");
            sheet.Columns[2].ColumnWidth = 11;
            sheet.Rows[4].RowHeight = 60;

            //Add a hyperlink to the image 
            picture.SetHyperLink("https://www.e-iceblue.com", true);
            
            //Save the result file
            workbook.SaveToFile("AddImageHyperlink.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace AddImageHyperlinks
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create a Workbook instance
            Dim workbook As Workbook = New Workbook()
            'Get the first worksheet 
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Insert an image into the worksheet
            Dim picture As ExcelPicture = sheet.Pictures.Add(5, 3, "Logo.png")
            sheet.Columns(2).ColumnWidth = 11
            sheet.Rows(4).RowHeight = 60

            'Add a hyperlink to the image 
            picture.SetHyperLink("https://www.e-iceblue.com", True)

            'Save the result file
            workbook.SaveToFile("AddImageHyperlink.xlsx", ExcelVersion.Version2013)
        End Sub
    End Class
End Namespace