本文将介绍如何使用Spire.XLS for Java来修改和删除Excel中的超链接。添加超链接的方法可参考此篇教程。

修改超链接

import com.spire.xls.*;
import com.spire.xls.collections.HyperLinksCollection;

public class ModifyHyperlink {
    public static void main(String[] args) {
        //加载示例Excel文档
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");

        //读取第一个工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        //获取超链接，修改文本信息及链接地址
        HyperLinksCollection links = sheet.getHyperLinks();
        links.get(0).setTextToDisplay("紫月公司收入统计");
        links.get(0).setAddress("https://www.11467.com/qiye/80122421.htm");

        //保存文档
        workbook.saveToFile("output/ModifyHyperlink.xlsx", ExcelVersion.Version2013);
    }
}

删除超链接

import com.spire.xls.*;
import com.spire.xls.collections.HyperLinksCollection;
public class RemoveHyperlink {
    public static void main(String[] args) {
        //加载示例Excel文档
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");

        //获取第一个工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        //获取工作表中的超链接
        HyperLinksCollection links = sheet.getHyperLinks();

        //移除超链接，并保留文本信息
        sheet.getHyperLinks().removeAt(0);

        //保存文档
        String output = "output/RemoveHyperlink.xlsx";
        workbook.saveToFile(output, ExcelVersion.Version2013);
    }
}