I'm using poi 3.9 and after attaching the sources I have tracked the issue to the ColumnHelper class, more specifically, the cleanColumns method.
There's a for loop inside, which runs over all the columns, calling the addCleanColIntoCalls method. I do not know what these methods do as of yet, but running them over all the columns of all the sheets is unwanted behavior for my purposes. I'll post here if I find out more. From: Nick Burch <[email protected]> To: POI Users List <[email protected]> Date: 10/23/2013 01:33 PM Subject: Re: slow loading XSSFWorkbook constructor due to column size On Wed, 23 Oct 2013, [email protected] wrote: > I've been experiencing slow loading times with the XSSFWorkbook > constructor, the program gets stuck for over 5 minutes during its call > and then returns the created object succesfully. Have you tried with the latest version of POI? There have been some fixes of late for this sort of thing > The problem occurs even when the excel sheets are empty and I've traced > the cause as being resized columns above the WWH1 range. > According to visualVM, the following methods are where most of the time is > spent: > org.apache.xmlbeans.impl.store.Locale.count() 48.6% > org.apache.xmlbeans.impl.store.Xobj.find_element_user() > 47.9% What in POI was calling xmlbeans? And what kinds of objects was xmlbeans searching for? Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
