excel-streaming-reader icon indicating copy to clipboard operation
excel-streaming-reader copied to clipboard

Not working with apache poi 5.0.0

Open DFromTheHood opened this issue 5 years ago • 8 comments

I am using both apache poi (for Excel creation) and this project (for reading large Excels). I have upgraded apache poi to the latest version, which is 5.0.0.

When for example obtaining a row iterator: sheet.rowIterator() I get the following stacktrace: `java.lang.NoSuchMethodError: org.apache.poi.xssf.model.SharedStringsTable.getEntryAt(I)Lorg/openxmlformats/schemas/spreadsheetml/x2006/main/CTRst;

at com.monitorjbl.xlsx.impl.StreamingSheetReader.unformattedContents(StreamingSheetReader.java:363)
at com.monitorjbl.xlsx.impl.StreamingSheetReader.handleEvent(StreamingSheetReader.java:200)
at com.monitorjbl.xlsx.impl.StreamingSheetReader.getRow(StreamingSheetReader.java:71)
at com.monitorjbl.xlsx.impl.StreamingSheetReader.access$200(StreamingSheetReader.java:32)
at com.monitorjbl.xlsx.impl.StreamingSheetReader$StreamingRowIterator.hasNext(StreamingSheetReader.java:402)
at com.monitorjbl.xlsx.impl.StreamingSheetReader$StreamingRowIterator.<init>(StreamingSheetReader.java:396)
at com.monitorjbl.xlsx.impl.StreamingSheetReader.iterator(StreamingSheetReader.java:382)
at com.monitorjbl.xlsx.impl.StreamingSheet.rowIterator(StreamingSheet.java:57)`

getEntryAt() is deprecated, and most likely removed by now: https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/model/SharedStringsTable.html

When can we expect this library to upgrade to apache poi 5.0.0? As I cannot upgrade because of this issue.

DFromTheHood avatar Jan 26 '21 14:01 DFromTheHood

See https://github.com/monitorjbl/excel-streaming-reader/issues/212#issuecomment-618936390

trueg avatar Jan 27 '21 09:01 trueg

The next version of this library will use POI 5.0.0

monitorjbl avatar Mar 24 '21 03:03 monitorjbl

The next version of this library will use POI 5.0.0

when the next version will be released? looking forward to it

boatrainlsz avatar Jun 02 '21 08:06 boatrainlsz

Looking forward for the next version.

lazydata avatar Aug 12 '21 13:08 lazydata

@monitorjbl is there any help required with the release? It looks like community has a big demand for it 🙂

aleksandrserbin avatar Sep 25 '21 09:09 aleksandrserbin

Argh, and I am trying to find out why almost EVERYTHING throws an UnsupportedOperationException or NoSuchMethodException on my side, another 3 monthts later :D

spyro2000 avatar Dec 14 '21 17:12 spyro2000

https://github.com/pjfanning/excel-streaming-reader/ uses the latest POI release - if that helps anyone

pjfanning avatar Mar 23 '23 10:03 pjfanning

https://github.com/pjfanning/excel-streaming-reader/ uses the latest POI release - if that helps anyone

It works, thanks very much.

jieyugithub avatar Sep 26 '23 08:09 jieyugithub