excel-streaming-reader

excel-streaming-reader copied to clipboard

Formulas not read on Formula Cells

2

if I'm not completely wrong, when reading the attached example XLSX File with version 2.10, some (but not all!) of the formulas on first sheet, fetched by StreamingCell.getCellFormula() are returned...

ghost

Is there a way to get images and mergeCells？

2

as the title says, I can't get images and mergeCells using excel-streaming-reader，Is there a way to do this?

boatrainlsz

The supplied data appears to be in the OLE2 Format

2

Getting below exception message while reading protected xlsx file. Is there a way to read protected file using StreamingReader.builder().rowCacheSize(6).open(is); Exception: The supplied data appears to be in the OLE2 Format....

JayneshAhir

Support DataFormatter

1

POI's DataFormatter calls Sheet.GetWorkbook in order to test for 1904 dates.

amjjd

StreamingWorkbook throws MissingSheetException when sheet is absent

4

interface `org.apache.poi.ss.usermodel.Workbook` states that `Sheet getSheet(String name)` method must return null if sheet doesn't exist. Why do you throw exception? It's absolutely unexpected behaviour!

niceman-zz

Hi, My test case is a xlsx file which has 1,000,000 rows and 97M. I use below code to parse it. ` return StreamingReader.builder() .rowCacheSize(50) .bufferSize(1024) .open(file);` (currenct version is...

danmaidesenling

fix for the Issue #186 -

1

when SST cache size is set, IndexOutOfBounds exception is thrown while processing the empty cells for some files. The file subject to the bug have been added to test resources

ismailozgen

AutoClosing doesn't seem to remove tmp files.

1

Thank you so much for this library, it saved us alot of time. I have a small question however? Using the example provided(code below) on the ReadMe.md and version 2.1.0...

GummyDonut

the excel has 1048576 rows, 31 columns,but sheet.getLastRowNum() = 0.jar version is 2.2.0

JianhuangShu

Hi All, Firstly, thanks for your contribution to this bravo project. And I see a tips below about sstCacheSize. So, Should I avoid to use sstCacheSize feature ? /** *...

danmaidesenling