Skip to Main Content
Forums

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Working with Big Excel Sheet

742528Mar 29 2011 — edited Mar 31 2011
Hello All,

I have a large excel sheet having 50K rows and I am constrained to not use more than 250 MB of Heap space.

Using Apache poi API the creating new WorkBook Object itself gives MemoryOutOfSpace Error

Workbook source = WorkbookFactory.create(new FileInputStream(Path));

Please suggest some solution/work around. I am open to use some other API as well but preference lies for Apache poi.


Thanks In Anticipation
Shivam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2011
Added on Mar 29 2011
#badgerbadgerbadger, #excel, #java
9 comments
7,483 views