You might give trunk a try, or wait until tomorrow when it is likely that POI 3.7beta3 will be released. (Voting is in process, no one has objected and enough positive votes so far. The link is on the thread - http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/19169)
If that fails to solve your issue then please submit a bugzilla entry. If possible a clean file attachment that demonstrates the trouble would really help. Dave On Sep 23, 2010, at 2:16 PM, Ryan Skow wrote: > > Using 'new XSSFWorkbook' within POI 3.7 beta 2 is very slow compared to doing > the same with the stable POI 3.6. The xlsx file in question has many > formulas which reference other cells which also contain formulas. In 3.6, > creating a new XSSFWorkbook takes about 10 seconds. In 3.7b2 it takes over > 10 minutes to get past the constructor. The relative time between the two > versions to open the same spreadsheet leads me to believe something is amiss > with 3.7b2. The only question related to 'slowness' in the FAQ is around > logging. As far as I know logging is not enabled with either configuration I > have been using and am specifically specifying the NullLogger. > > Please let me know what additional information would be useful. I mainly am > just curious if anyone else is experiencing the slowdown or if it is > something specific to my spreadsheet or if there is a quick fix. > > Thanks! > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
