File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Other Open Source Projects
Strange behavior of getrow(n) method of Sheet interface in jxl api
Joined: Sep 08, 2010
Sep 12, 2010 00:38:47
I am processing an
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 ?
Joined: Oct 27, 2005
Sep 12, 2010 09:42:31
Moving to Other Open Source
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions
How To Answer Questions
Joined: Oct 08, 2009
Jun 16, 2011 04:35:16
I also have same problem. Any solution guys??
I agree. Here's the link:
subject: Strange behavior of getrow(n) method of Sheet interface in jxl api
regarding POI HSSF programming
POI 3.6 XSSF
Copy particular rows in excel using POI
The system cannot find the path specified
Read a .xls,.xlsx file format using XSSF
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015