alusbars

Hi, FYI It doesn't work with latest apache POI 3.16. Tested with previous 3.15 with successful iterating through all dataset.

From documentation: You may access cells randomly within a row, as the entire row is cached. However, there is no way to randomly access rows. As this is a streaming...

No other way than you need to initialize workbook again.

Streaming approach is not memory consumable by definition in terms of RAM. You won't have OutOfMemoryError what is more important, but of course you should consider your hard disk storage....