This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 19655
    
  18

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
 
Similar Threads
The system cannot find the path specified
POI 3.6 XSSF
Read a .xls,.xlsx file format using XSSF
regarding POI HSSF programming
Copy particular rows in excel using POI