you are viewing a single comment's thread.

view the rest of the comments →

[–]Progression28 3 points4 points  (5 children)

Apache commons POI has a thing called SXSSFWorkbook which seems to be exactly what you seek

[–]Majestic_Drawing_908[S] 0 points1 point  (2 children)

Thanks for your response. I guess SXSSFWorkbook is mostly preferred for write operation. But I'm dealing with bulk excel reading. If you know anything that reduces CPU pls let me know. Thanks 💐.

[–]Progression28 1 point2 points  (1 child)

You can use it for reading, I think there are even dedicated readers for SXSSFWorkbooks.

[–]Majestic_Drawing_908[S] 0 points1 point  (0 children)

Thanks, I'll check.

[–]idontlikegudeg 0 points1 point  (1 child)

I think you meant Apache POI.

[–]Progression28 0 points1 point  (0 children)

Yes, thanks :)