excel-streaming-reader

excel-streaming-reader copied to clipboard

Any Reason why xml-apis/xerces2 is included?

1

Hello, is there any reason why the following dependencies are included: ``` com.rackspace.apache xerces2-xsd11 2.11.1 xml-apis xml-apis 1.4.01 ``` ? The project supports only Java 1.7+ so JAXP is there...

schmitch

This dataset causes out of memory error

8

[This dataset](https://drive.google.com/file/d/1ScbTPNA-lBmC1Ogz75DogjyirDIk9duJ/view) runs for several hours and eventually runs out of heap space Possibly the issue is the large number of unique strings?

davidw76

Can't iterate over files that contains over 1 milion rows

2

Ran into this issue for a file I'm working on that is close to 1,5 million rows and covers two sheets. This is the basic iterator I'm running: for(Row row:wb.getSheetAt(0)){...

Stromner

I tried adding the dependencies: / / https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 libraryDependencies += "org.slf4j" % "slf4j-log4j12" % "1.7.10" % Test did n't help. Any kind of help is really appreciated.

ajanac

DataFormat : StreamingWorkbook#createDataFormat()

3

First of all I (being pained by OOMs due to POI Excel imports ;) ) would like to say how impressed I am by the low footprint of this streaming...

clemensdev

Does it support android studio?

4

 ``` Error:com.android.build.api.transform.TransformException: com.android.builder.packaging.DuplicateFileException: Duplicate files copied in APK schemaorg_apache_xmlbeans/system/sF1327CCA741569E70F9CA8C9AF9B44B2/stqualifier91b9type.xsb ``` 

DanteAndroid

Quoted value of a formula cell

1

Hi! I've noticed that for a formula cell the value is returned in quotes. Is this by design? What is the reason for it? In particular, if the value is...

antone-sb

Sometime, the method getLastRowNum() return ZERO

1

I tested with an excel file (file format was xlsx extension) and there are no special things inside) but sheet.getLastRowNum() was returned ZERO. Could anyone give me a suggestion for...

dgks0n

Could not read file. NumberFormatException

1

https://yadi.sk/d/7N-lbmgA3MGqCM - this one. Read it as described in your project's main page. ``` Exception in thread "main" java.lang.NumberFormatException: For input string: "1 " at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:580) at java.lang.Integer.parseInt(Integer.java:615)...

bvn13

Hi guys, i've got such file and wonder why i have exception due to plain iterating with StreamingWorkbook. [Athlete Medals.xlsx](https://github.com/monitorjbl/excel-streaming-reader/files/1094216/Athlete.Medals.xlsx) The reason is BufferedStringsTable::parseCTRst , xmlEventReader.nextEvent() return EndElementEvent which cannot...

alusbars