如何删除超链接POI 3.8？ [英] How can I remove hyperlink in poi 3.8?

问题描述

我有一些问题，读取Excel文件中包含POI超链接文本。

I have some problem with reading an excel file contains hyperlink text in poi.

数据就是这样（Excel文件）：结果
| 1 | 键入 | 类别 | 工作类型 | 位置 | 命名 | 电子邮件结果
| 2 |测试|开发商|兼职|经理|红|航空自卫队## @ dsaf.com（超级链接的）结果
| 3 |测试|开发商|兼职|经理| ASDE | [e-mail]（超级链接的）结果
| 4 |测试|开发商|兼职|经理| ASDE | AAAAAAA（非超级链接的）

Data is like that(excel file):
|1| type | category | job_type | position | name | email
|2| Test | developer | parttime | manager | hong | asdf##@dsaf.com(hyperlink)
|3| Test | developer | parttime | manager | asde | [e-mail](hyperlink)
|4| Test | developer | parttime | manager | asde | aaaaaaa(non-hyperlink)

要创建工作簿对象，我用 WorkbookFactory.create（INP的InputStream）方法。结果
codeS在这里：

To create workbook object, I use WorkbookFactory.create(InputStream inp) method.
Codes are here:

public POIExcelImport(String name, InputStream inputStream) throws ExcelImportException {
    super(name, null);
    try {

        logger.debug("before work : {}", this.workbook);

        this.workbook = WorkbookFactory.create(inputStream);// exception 

    } catch (InvalidFormatException e) {
        throw new ExcelImportException(e);
    } catch (IOException e) {
        throw new ExcelImportException(e);
    } 

    if(XSSFWorkbook.class.isAssignableFrom(workbook.getClass()))
        this.type = ExcelFileType.XLSX;
    else
        this.type = ExcelFileType.XLS;
}

当我称之为创建方法，引发的异常。

When I call create method, Exception was thrown.

java.lang.IllegalStateException: The hyperlink for cell F2 references relation rId1, but that didn't exist!
at org.apache.poi.xssf.usermodel.XSSFHyperlink.<init>(XSSFHyperlink.java:71) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.xssf.usermodel.XSSFSheet.initHyperlinks(XSSFSheet.java:204) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:157) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:129) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:269) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:183) ~[poi-ooxml-3.8.jar:3.8]
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:73) ~[poi-ooxml-3.8.jar:3.8]
at dreaminfra.ipams.common.excel.poi.POIExcelImport.<init>(POIExcelImport.java:49) ~[ipams-core-1.0.0.jar:na]

我想删除的超链接，但也有关于创建超链接只是问题。结果
我没有想法，有什么想法？

I want to remove hyperlink, but there are only issues about to create hyperlink.
I don't have idea, is there any idea?

推荐答案

我发现这是我的系统上工作：

I found this to work on my system:

ICell oCell = workbook.GetSheetAt(0).GetRow(0).GetCell(0);
IHyperlink oLink = oCell.Hyperlink;
oLink.setFirstRow(0);
oLink.setLastRow(0);
oLink.setFirstColumn(0);
oLink.setLastColumn(0);
oLink.setLabel(null);
oLink.setAddress("");

请注意：我主要是与NPOI（C＃版本）不POI（Java版本）的工作，但它似乎工作是一样的。此外，一定要保持 .setAddress（）末页。

Note: I'm primarily working with NPOI (C# version) not POI (Java version), but it seems to work the same. Also, be sure to keep the .setAddress() last.

编辑：不幸的是这似乎导致无法通过Excel中由于某种原因被保存的文档。 （Excel中检测到损坏的Save），所以它实际上并没有在实际工作中，看起来就像有人将不得不修补NPOI库为这一个。

Unfortunately this seems to cause documents that cannot be saved by Excel for some reason. (excel detects corruption on save) So it doesn't actually work in practice, looks like someone will have to patch the NPOI repository for this one.

这篇关于如何删除超链接POI 3.8？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！