https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
--- Comment #12 from Thamodharan <[email protected]> --- (In reply to Yegor Kozlov from comment #11) > try to construct SXSSFWorkbook in a different way: > > wb = new SXSSFWorkbook( > null, /* template workbook. pass null to start with a blank workbook */ > 1000, /* size of the sliding window*/ > true, /* whether to compress temp files.*/ > true /* whether to use shared string table*/ > ); > > > > not that it may increase the memory footprint, especially if the number of > distinct strings is large . Hi Yegor Kozlov, As you stated, it worked fine, if a same string is written in all the cells (500 Row X 150 Column). Even it is good if same string written in (750 rows X 150 Column). Thus by digging more about it,I came to know how shared string table concept works. But for more number of distinct string that need to be inserted, i face java heap space out of memory error, since shared string takes all distinct in into heap memory. Help me to improve it further. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
