Hyperlinks - How to remove them.

[alexandretperez]

Hi all,

I'm trying to remove an hyperlink from a cell using the below code:

public void RemoveLink()
{
	var filePath = @"C:\Temp\Book1.xlsx";
	
	var workbook = WorkbookFactory.Create(filePath);
	var address = new CellReference("A1");
        var sheet = workbook.GetSheet("Sheet1");
	var cell = sheet.GetRow(address.Row).GetCell(address.Col);
	
	((XSSFSheet)sheet).RemoveHyperlink(address.Row, address.Col);

	using (var fs = File.Open(filePath, FileMode.Create, FileAccess.Write))
		workbook.Write(fs);
}

But nothing happens, the hyperlink is still there.

Am I missing something?

[tonyqus]

At first glance, this looks to be a bug

[alexandretperez]

Hi @tonyqus ,

It seems so. I also tried setting null to cell.Hyperlink property and save it. But it didn't work too.

I'm still trying to figure out a solution.

[alexandretperez]

Hi @tonyqus

One last comment, the issue seems to happen only with XLSX files indeed.

public void RemoveLink(string ext)
{
    var filePath = @"C:\Users\833741\Downloads\Book." + ext;
    var workbook = WorkbookFactory.Create(filePath);
    var address = new CellReference("A1");
    var sheet = workbook.GetSheet("Sheet1");
	
    if (ext == "xls")
        ((HSSFCell)sheet.GetRow(address.Row).GetCell(address.Col)).RemoveHyperlink(); // this one is working fine. (xls)
    else
        ((XSSFCell)sheet.GetRow(address.Row).GetCell(address.Col)).RemoveHyperlink(); // trying this way also does not work. (xlsx).

    using (var fs = File.Open(filePath, FileMode.Create, FileAccess.Write))
        workbook.Write(fs);
}

[tonyqus]

This issue is fixed in #690