I am in the process of evaluating java cells and have run across an issue when using the method:
row.getCellIterator();
If I have 4 columns in my spread sheet and the second column is left blank sometimes the iterator has 4 cells and other times it has 3. Note there is no data in any of the cells within the column. My expection would be that I would receive an empty string for each cell but and there would alway be 4 cells in the iterator.
Note the column index is right for the cells that are returned. It just seem to skip the blank ones in some cases.
Is this a bug or just how it works?
Jim