aspose file tools*
The moose likes Other Open Source Projects and the fly likes Strange behavior of getrow(n) method of Sheet interface in jxl api Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Strange behavior of getrow(n) method of Sheet interface in jxl api " Watch "Strange behavior of getrow(n) method of Sheet interface in jxl api " New topic
Author

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

R Dom
Greenhorn

Joined: Sep 08, 2010
Posts: 19
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 ?


Cheers,
RD
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19762
    
  20

Moving to Other Open Source APIs Projects.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
chirag jain
Greenhorn

Joined: Oct 08, 2009
Posts: 6
I also have same problem. Any solution guys??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Strange behavior of getrow(n) method of Sheet interface in jxl api