Hello,
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.
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%
I only want to read data from the xlsm and have no interest in column
widths.
Is there a way to configure apache.poi to ignore visual information during
the opening of the file?
Cu stima / Mit den besten Gruessen / Best regards,
Mihai Cristea
