Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Working with Big Excel Sheet  RSS feed

 
Shivam Goel
Greenhorn
Posts: 2
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Darryl Burke
Bartender
Posts: 5167
11
Java Netbeans IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shivam, please BeForthrightWhenCrossPostingToOtherSites
http://forums.oracle.com/forums/thread.jspa?threadID=2198739
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!