File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes I/O and Streams and the fly likes Reading Excel File from a POJO Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Reading Excel File from a POJO" Watch "Reading Excel File from a POJO" New topic

Reading Excel File from a POJO

Pooja Dornadhula

Joined: Aug 07, 2007
Posts: 8
I am using the below code to read the Excel file. But i am not able to come out of the for loop of result set. Please help me in this issue.


public Object populateData(File file){
Connection conn = null;
PreparedStatement dataQueryPS = null;
ResultSet dataQueryRS = null;
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
conn = DriverManager.getConnection("jdbc dbc river={Microsoft Excel Driver (*.xls)};DBQ=" + file);
String dataQuery = "Select REFNO,DDNO,URL,DATE from [Sheet1$] where REFNO <> null";
dataQueryPS = conn.prepareStatement(dataQuery);
dataQueryRS = dataQueryPS.executeQuery();
for(int i = 0 ;;i++){
System.out.println("i :::: "+i +" "+dataQueryRS.getString(1));
return null;
catch(Exception e){
return null;
System.out.println(" Iam in final try");

}catch(Exception t){



Pooja D

SCJP 1.4, SCWCD 1.4
Joe Ess

Joined: Oct 29, 2001
Posts: 8710

As I said in your previous post, some Excel spreadsheet versions have over a million rows. How many rows are you printing out?
By the way, please Use Code Tags when you post code.

"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
krishnamoorthy kitcha
Ranch Hand

Joined: Feb 04, 2006
Posts: 96
Hi pooja !!!

check in this line

dataQueryPS = conn.prepareStatement(dataQuery);
This is Returns the PreparedStatement not a result set

dataQueryRS = dataQueryPS.executeQuery();
Here only, returns the resultset

check and tell me your feedback
It is sorta covered in the JavaRanch Style Guide.
subject: Reading Excel File from a POJO
Similar Threads
File as Attachment in J2ME client
problem while reading data from excel sheet
mysql connectivity with jboss
Method keeps returning null
How to send bytearray from Servlet to Midlet application?