David Webb

Results 6 comments of David Webb

the dataset contains many unique string values it looks like "SharedStringsTable" is getting too large. Is there any way to avoid this? `java.lang.OutOfMemoryError: Java heap space at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1700) at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1303)...

I think that the sstCacheSize option was removed

I am using the latest. If I add the option I get the runtime error below. Is this an unsupported excel version? `java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTPhoneticRun at java.lang.Class.getDeclaredMethods0(Native Method) at java.lang.Class.privateGetDeclaredMethods(Class.java:2701) at...

ok I see I need ooxml-schemas.. I will give it a try

for some reason, when I use sstCacheSize with this dataset, I now have to use the full ooxml-schemas instead of the reduced set of poi-ooxml-schemas

I was able to get it running but it still fails to load the dataset.. with sstCacheSize(100)