Free Support Forum - aspose.com

Java Cells Skipping cells when columns is empty

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

Hi Jim,

We will skip the cell which is not initial when getting Cell Iterator.The method is used to help user quick to iterate all defined cells in this row.