search

monitorjbl / excel-streaming-reader

An easy-to-use implementation of a streaming Excel reader using Apache POI
Apache License 2.0
960 stars 345 forks source link

Unable to use rowIterator twice from same sheet object #216

Closed NiharGharat closed 4 years ago

NiharGharat commented 4 years ago

I wanted to correct the list created after iterating over the entire sheet with the rows and columns which have been skipped due to iterator skipping them as they were empty. I am using a pointer variable to do so(same as in apache poi), getting the maximum number of cells in any row by iterating over the rows completely once, and finding the max, and filling it up later. This works well in apache poi, but here, I am not able to use a new Iterator<Row> object from same sheet object, once I have iterated using old iterator object. The hasNext() returns false.

So, is there a way using streaming, to find the maximum number of cells per row present in a sheet; or to use the iterator again from the same sheet object?

NiharGharat commented 4 years ago

Links to #97 . Closing as this is limitation.