excel-streaming-reader

excel-streaming-reader copied to clipboard

Not able to Read Formula cell value as data

1

Using apache poi able to read formula cell value as data but not using monitorjbl, as getCreationHelper().createFormulaEvaluator() it is unsupported . is there any other option to read formula cell...

sairaj61

How do we mention charset for reading stream to read European characters as is in file.and write it to CSV using csvwriter. Is there an option to mention charset for...

Yethindra

Streaming reader taking Huge CPU to read 100 records.

1

0 I am trying to upload 100k records from xlsx file and using Excel Streaming Reader to iterate excel It was failing in QA server but made changes StreamingReader.builder() .sstCacheSize(100)...

ghousemsyed

StreamingSheetReader$StreamingRowIterator requires hasNext() being called before next()

2

This will throw a NoSuchElementException, even if the sheet has 3 or more rows. ```java Workbook workbook = StreamingReader.builder() .rowCacheSize(2) .open(new ByteArrayInputStream(bytes)); Sheet sheet = workbook.getSheetAt(0); Iterator rowIt = sheet.rowIterator();...

koch-rsi

Hi, We are using apache poi API to read the xlsx files and getting the OutofMemory issue for the attached file. Can you please check and suggest me what is...

rkanumola

Hello, thank you for the library, could you help me, please, get ByteArrayOutputStream from workbook. I try to use: ByteArrayOutputStream bos = new ByteArrayOutputStream(); workbook.write(bos); but I get an exception...

Maratonline

NullPointerException when building BufferedStringsTable

1

Version `2.1.0` If I import an Excel document with the `sstCacheSize` set to a positive value I get a NullPointerException. `java.lang.NullPointerException: null at com.monitorjbl.xlsx.sst.FileBackedList.writeToFile(FileBackedList.java:74) ~[xlsx-streamer-2.1.0.jar:na] at com.monitorjbl.xlsx.sst.FileBackedList.add(FileBackedList.java:52) ~[xlsx-streamer-2.1.0.jar:na] at com.monitorjbl.xlsx.sst.BufferedStringsTable.readFrom(BufferedStringsTable.java:43)...

jamesblewitt

New release for Apache POI 4.1.1 ?

1

Would it be possible to generate a new release for Apache POI 4.1.1 ? The current release has Maven dependencies with Apache POI 4.0.0 Thanks

Guillaume789

NoSuchMethod error

2

i got this error when tried to use this. Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.openxml4j.opc.OPCPackage.open(Ljava/io/File;)Lorg/apache/poi/openxml4j/opc/OPCPackage; i doubt this issue arise due to any version isssue with jar files. could you...

jerin25

I know you state that the more advanced methods are not supported. Surely this isn't an advanced method? Using this gives me a UnsupportedOperationException Edit - I can see it's...

gormleymark