Strange behavior of getrow(n) method of Sheet interface in jxl api

[ron87]

I am processing an excel sheet having 20 rows and 20 columns.

I am reading excel sheet row by row. Using sheet.getrow(n) method.

The excel sheet does not contain data for all columns.

I am able to read rows who have data only for 19 columns.

There is one row (rownumber=18) in sheet which has data till 12 columns.

So in my code when i call sheet.getrow(18) , it returns me array of length 12 and not 20. (though column count is 20)

But although some other rows have data till 19th column it returns me array of size 20 and not 19.

Quiet strange behavior..!

Does anyone know solution to this ?

[Tolls]

There's no solution.
That's Excel, which seems to only hold data for cells that have data in...but sometimes also notes empty cells. So the "extra" cell in the rows with 19 data cells is one of those exceptions.

Of course this does beg the question of what problem this is causing you, since you are asking for a solution.

[ron87]

But for the row in which 20th cell is empty... the method returns me an empty string
Then for the row having 13 data cells and remaining 7 empty the method should return me 13 data cells and 7 empty strings... but its not doing that... it only returns me 13 data cells

[Tolls]

No.
Excel does not guarantee that there is something in its file for every empty cell.
Consequently, as you are seeing, you will simply not have a Cell at all.

In POI, for example, (method names not necessarily accurate) row.getCell(1) might return null, even if row.getCell(2) returns something.

JExcel has a similar thing.

[ron87]

oh ok... i was confused for that reason..
So i changed my code and now I am not reading data row-wise..
Thanks

[Tolls]

Yep, Excel is fun like that.
It's not a CSV, that's for sure.