How to remove hyperlinks from hyperlink collection

1 min read

The code snippets for removing hyperlinks form its collection using XlsIO is shown below.

            IWorksheet sheet = workbook.Worksheets[0];
            IRange range = sheet.Range["A1:A3"];
            if (range.Hyperlinks.Count > 0)
                for (int i = range.Hyperlinks.Count; i >= 1; i--)
                {
                    range.Hyperlinks.RemoveAt(i-1);
                }
            workbook.Version = ExcelVersion.Excel2010;

            Dim sheet As IWorksheet = workbook.Worksheets(0)
            Dim range As IRange = sheet.Range("A1:A3")
            If range.Hyperlinks.Count > 0 Then
                Dim i As Integer
                For i = range.Hyperlinks.Count To 1 Step i - 1
                    range.Hyperlinks.RemoveAt(i - 1)
            End If
                Next
 
            workbook.Version = ExcelVersion.Excel2010