HI , We are using poi3.9 for reading and writing excel via java. 1. For writing optiong we are using SXSSFWORKBOOK . 2 . but we could not use SXSSFWORKBOOK for read . also we could not use XSSFWORKBOOK .because we are loading huge records . 3 . for huge records if we use XSSFWORKBOOK wb = new XSSFWORKBOOK () cocept means we got the out of memory error . please help me .
Have you checked http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api ?
Please do not use Bugzilla for asking usage questions, that should be done on the mailing lists - http://poi.apache.org/mailinglists.html . Bugzilla is only used for reporting problems, and proposing fixes / enhancements