• Post Reply Bookmark Topic Watch Topic
  • New Topic

POI and HSSF

 
Dan Peterson
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have been messing around alittle bit with HSSF and have been searching the web for some answers but havent found any hopefully someone can help.

When I create my new workbook does it load the whole thing into memory? So if I have 28,000 6 columns each they will all be loaded into memory at once? If this is the case is there a way to split up how many rows are stored in memory at a given time?
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch.

POI definitely needs lots of memory for large worksheets. I can't say with confidence one way or the other, but my impression is that it does indeed load the entire document into memory. And, like you, I have seen no suggestion or API method that would tell it to do it differently. Although, in fairness, that may not be POIs fault - it could very well be that the XLS document structure does not support anything else.
I'm not sure if jExcelAPI is better in this regard, but it might be worth a shot if the memory demands otherwise prove to be too much.
 
Dan Peterson
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank you for the reply Ulf, I will take a look at jExcelAPI!
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!