excel-streaming-reader
excel-streaming-reader copied to clipboard
An easy-to-use implementation of a streaming Excel reader using Apache POI
[成人上传模板正常的文件模板(1).xlsx](https://github.com/monitorjbl/excel-streaming-reader/files/2192561/1.xlsx) In my machine, the library doesn't work and exception is thrown as below. But it can work well in other machines. What can be the cause? Exception Details: Location:...
If a cell contains a hyperlink then it's supported method is not implemented in the library.
`poi-ooxml` already depends on `poi-ooxml-schemas,` wihch is a substantially smaller version of the `ooxml-schemas` jar. According to [POI website](https://poi.apache.org/overview.html), the larger `ooxml-schemas` jar is normally only required for development. Removal...
it cost several minute to read a > 50000 row xlsx file using code: workbook = StreamingReader.builder() .rowCacheSize(100) .bufferSize(4096) .open(is); even slower then workbook = WorkbookFactroy.create(is)
I am trying to create the object of the workbook. The sheet is password protected and the sheet size is 150 MB. When I am trying to open the stream:...
Does it support poi 3.9 ?
I have noticed a difference between initial WorkBook by a File or InputStream. For example, there is a xlsx file: ``` wb = StreamingReader.builder() .rowCacheSize(1000) .bufferSize(4096) .open(file); // .open(is) ```...
I 'am trying to get hyperlink of a cell and also the label by this way ``` Row row=rowIterator.next(); Iterator cellIterator = row.cellIterator(); currentCell = cellIterator.next(); parthyperlink=currentCell.getHyperlink().getAddress(); String label=currentCell.getHyperlink().getLabel(); ```...
@monitorjbl I could able to open the excel in compatibility mode but through code I am facing the issue as such the cellTypeEnum returns numeric and throws error. Thought to...
I am using 1.2.0 version for Excel Streaming Reader. Following is what I have in my POM.xml file: - dependency - groupId com.monitorjbl /groupId - artifactId xlsx-streamer /artifactId - version...