POI生成的Excel工作簿在链接时不起作用

Here is what I'm doing :

这是我正在做的事情:

1. Create a workbook in memory (book = new HSSFWorkbook(), ...)

在内存中创建工作簿(book = new HSSFWorkbook(),...)

2. Save it to disk (book.write(...))

将其保存到磁盘(book.write(...))

3. Open in Excel (ok)

在Excel中打开(ok)

4. Create another workbook in Excel, which links to the first one (=PoiWorkbook?xls!A1)

在Excel中创建另一个工作簿,链接到第一个(= PoiWorkbook?xls!A1)

5. Close Excel

Then everytime I open the second workbook again, all the links are #N/A, unless I also open the POI-generated workbook at the same time.

然后,每次我再次打开第二个工作簿时,所有链接都是#N / A,除非我同时打开POI生成的工作簿。

I never saw this behaviour with standard workbooks created in Excel. Anyone has seen this and found a workaround ?

我从未在Excel中创建标准工作簿时看到此行为。有人见过这个并找到了解决方法吗?

Thanks.

1 个解决方案

#1

This issue seems to be solved by newer version of POI (using 3.6 right now).

这个问题似乎可以通过更新版本的POI解决(现在使用3.6)。