Excel workbooks created by POI do not work when linked

That's what I'm doing:

  • Create a book in memory (book = new HSSFWorkbook (), ...)
  • Save it to disk (book.write (...))
  • Open in Excel (ok)
  • Create a new workbook in Excel that links to the first one (= PoiWorkbook? Xls! A1)
  • Close Excel

Then every time I open the second book again, all links are: # N / A unless I also open the POI generated book at the same time.

I have never seen this behavior with standard workbooks created in Excel. Has anyone seen this and found a workaround?

Thank.

+1


source to share


1 answer


This issue appears to have been resolved by a newer version of POI (using 3.6 now).



+1


source







All Articles