SXSSF in POI 3.8

[David González Casín <da...@softproject.de>]

Hi,

 

I have the problem to open some Excel files, I guess it's nearly the same
problem described here:
https://issues.apache.org/bugzilla/show_bug.cgi?id=48261

 

The last answer gives the hint that it can be solved with POI 3.8, but I
don't know how. I tried with HSSFWorkbook and XSSFWorkbook, but with both it
doesn't work (same behavior as in POI 3.7). Then I read something about
SXSSFWorkbook, but there are only examples to write an Excel file, not to
read. I'm not sure if it is possible with SXSSF at all or if I need
something else.

 

Could you help me and give a little code example or a hint?

 

Best regards

 

David