excel-streaming-reader

excel-streaming-reader copied to clipboard

Algouth classes set in BeforeAll method Locale.setDefault(Locale.ENGLISH) 2 tests are failing due actual values in differet language. Tested on our company machnine with German system locale and my developer machine...

rimuln

In **version 2.2.0** `cell.getSheet().getWorkbook()` throws `NotSupportedException()`. This is used to retrieve value from cell based on type in `DataFormatter.formatCellValue()`.

prem-parmar

cell.getSheet() - NotSupportedException()

2

In version **2.1.0** `cell.getSheet` throws `NotSupportedException()` This is used in `DataFormatter.formatCellValue()` what is suggested way to retrieve value from cell based on type. I've seen from commits that this method...

tkluza

java.lang.NullPointerException at com.monitorjbl.xlsx.impl.StreamingSheetReader.setFormatString

1

Hi, @monitorjbl, when I try to read excel file with millions of rows, it will meet up NullPointerException. StreamingReader.builder().rowCacheSize(1000).bufferSize(100 * 1024 * 1024).open(inputStreamProvider) The error is happened in "SteamingWorkbookReader.java" and...

yuzhangyi

I want to read excel properties, streaming-reader is not support.

jaffreyen

xlsx streamer api 2.1.0 is not working with poi 4.1.1

5

Can see that changes to xlsx streamer api are done to support poi 4.1.0 but not release yet. May I know when are planning to release xlsx streamer api to...

ragivenkatesh

StreamingWorkbook、StreamingSheet、StreamingRow实现了poi里面的抽象接口，但是很多方法没有具体实现，直接抛出UnsupportedOperationException，如果之前的代码使用的是HSSF、XSSF、SXSSF等原生类，迁移到Streaming时，代码编译没有问题，但是在运行时可能会因为部分方法不支持，抛出UnsupportedOperationException，导致原来的功能受到影响。 建议对不支持的方法在编译期会有个提示或者直接编译不通过。

cdn198

Using LibreOffice on Linux, we created an xlsx file where the dates were off by 5 years and a day when parsing. It turned out that the attriibute `date1904` may...

oyvindwe

StreamingReader cannot read all data from one sheet

1

Hi, @monitorjbl , when I try to use StreamingReader to read data from one worksheet, it only return the data in cached rows (for example, 100 rows of data, but...

yuzhangyi

How to get row count if there is only one sheet

1

I am getting correct row count if there are two or more sheets but getting always 0 if there is only one sheet. I am executing this code. Sheet sheet...

JavaGuruLMKR