File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
R Dom
Greenhorn
Posts: 19
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Rob Spoor
Sheriff
Pie
Posts: 20369
44
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to Other Open Source APIs Projects.
 
chirag jain
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I also have same problem. Any solution guys??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic