apache poi - Open Large Existing Excel Document in Java -

this question has answer here:

i attempting open large excel document (about 150,000 rows of 6 columns) using apache poi in java remove entire worksheet. when try

wb = new xssfworkbook("output/boss.xlsx");

i get

exception in thread "main" java.lang.outofmemoryerror: java heap space

i not sure else do. unfortunately server trying on running 1.5 limited on can use/do. apparently sxssf works writing, not reading, files.

does have sort of suggestion might able use/try?

edit: excel file 2.5mb if matters

it seems best way parse data excel document use poi sax parser. can find more information on here: http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api

the problem have how use delete worksheet being parsed. make new question if cannot figure out.

Brazille