Hi Yegor, >// almost 10x slower than XSSF! >There is something to work on.
I ran the SSPerformaceTest and found the following values: HSSF default 10000x100 5 sec SXSSF default 10000x100 7sec I did not do the XSSF test because my VMWare doen't have that much heap space. But never mind, the HSSF value is the same as in your test and the SXSSF value is slightly above, which is 5 times faster then XSSF so that I can't reproduce your 302 seconds. Did you use the original SSPerformanceTest or a modified version? >Alex, would you like to continue working on this feature and submit more patches? Absolutely, but keep in mind that for the moment my Excel knowlege is minimal. I will look into the two issues Boolean and Formulas and I am confident to having that work as expected. Is there a unit test for the Cell class? Besides of issues writing the XML, I suspect strongly that the current implementation has a number of bugs in the getters/setters. As an example consider setting a cell type to string and then setting a numeric formua (Formulas are typed in Excel, no?). Is that an error or should the type change to numeric then? My feeling is, that it would be more productive if you took care of that part of the code. I think that I can manage to get the XML right without too much trouble. What do you think? Regards, Alex -- View this message in context: http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-51160-New-PATCH-Provide-ability-to-produce-very-large-xlsx-files-using-the-regular-B-tp4375895p4403468.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
