How to clear all the Hyperlinks in the Workbook?

[hpstep]

I used SetCellHyperLink but it didn't work. Do you have any solutions? Thank you~

[xuri]

Thanks for your issue. Which version of the Excelize library are you using? Could you show us a complete, standalone example program or reproducible demo? Could you follow the issue template to provide more details? If you open an existing workbook, please provide the file attachment without confidential info.

[hpstep]

if err := f.SetCellHyperLink("Sheet1", "A3",
    "", "External", excelize.HyperlinkOpts{
        Display: nil,
        Tooltip: nil,
    }); err != nil {
    fmt.Println(err)
}

我使用以上代码去修改超级链接。但是用Excel打开之后，鼠标指过去还是显示有超级链接。 我想知道是否有函数清除这些超级链接，类似在Excel中右键取消超级链接一样。

[xuri]

Could you follow the issue template to provide more details? If you open an existing workbook, please provide the file attachment without confidential info.

[hpstep]

Description I used SetCellHyperLink but it didn't work. Do you have any solutions? Thank you~

Steps to reproduce the issue: 以下是简单测试的代码

f := excelize.NewFile()
defer func() {
    if err := f.Close(); err != nil {
        fmt.Println(err)
    }
}()
// 创建一个工作表
_, err := f.NewSheet("Sheet2")
if err != nil {
    fmt.Println(err)
    return
}
f.SetCellValue("Sheet1", "A2", "Hello world.")
f.SetCellValue("Sheet2", "A2", "Hello world.")

display, tooltip := "https://github.com/xuri/excelize", "Excelize on GitHub"
if err := f.SetCellHyperLink("Sheet1", "A2",
    display, "External", excelize.HyperlinkOpts{
        Display: &display,
        Tooltip: &tooltip,
    }); err != nil {
    fmt.Println(err)
}

if err := f.SetCellHyperLink("Sheet1", "A2",
    "", "External", excelize.HyperlinkOpts{
        Display: nil,
        Tooltip: nil,
    }); err != nil {
    fmt.Println(err)
}

if err := f.SaveAs("LinkBook.xlsx"); err != nil {
    fmt.Println(err)
}

Describe the results you received: 在Shee1中。A2的超级链接没有被清除，鼠标指过去之后还会出现跳转的提示和鼠标指针变化。右键还是会出现“取消超级链接的菜单项”

Describe the results you expected: 期望可以清除超级链接，例如结果跟（Sheet2的A2一样）

Output of go version: 1.22.4

Excelize version or commit ID: Excelize version 2.8.1

Environment details (OS, Microsoft Excel™ version, physical, etc.): LinkBook.xlsx

[xuri]

Thanks for your feedback. This library doesn't support remove hyperlink for a cell, I'll consider adding support for this.

[xuri]

I added remove hyperlink support for the SetCellHyperLink function. Please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master, now you can remove hyperlink for cell Sheet1!A2 like this:

if err := f.SetCellHyperLink("Sheet1", "A2", "", "None"); err != nil {
    fmt.Println(err)
}

This feature will be released in the next version.

[hpstep]

谢谢您，我可以使用了~~