Strange behavior of getrow(n) method of Sheet interface in jxl api
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 ?