https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
--- Comment #19 from Thamodharan <[email protected]> --- My machine specs, Jboss server RAM 32 GB Heap size allocated to jboss 28 GB Harddisk 1 TB I am good to go with generating excel file upto a limit of 0.3 million X 200 rows with enabling shared string. Ahead such row, i face corrupt file issue when opening the generated excel. The reason for this error as stated by greg woolsey is, the data's are stored as inline string in the disk, thus excel couldn't tolerate putting such large number of inline string, thus repairing it, turning inline to single shared string. As suggested by greg woolsey, its better to go by enabling shared string, which holds unique data in heap space instead of disk space. This idea may aid the application to generate a single excel file in my machine with the above spec, but generating 2 or more excel at same time, will lead to memory out. I guess, writing a patch to store data in disk, rather in heap, will again lead to inline string and same error may occur. Can anyone from apache dev team or other followers, ignite a vice idea to rule this error out ? Waiting a good response Thamodharan B -- 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]
