File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Reading Excel File from a POJO" Watch "Reading Excel File from a POJO" New topic
Author

Reading Excel File from a POJO

Pooja Dornadhula
Greenhorn

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.

------------------------------CODE----------------------------------------

public Object populateData(File file){
Connection conn = null;
PreparedStatement dataQueryPS = null;
ResultSet dataQueryRS = null;
try{
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 ;dataQueryRS.next();i++){
System.out.println("i :::: "+i +" "+dataQueryRS.getString(1));
}
return null;
}
catch(Exception e){
e.printStackTrace();
return null;
}finally{
try{
System.out.println(" Iam in final try");

dataQueryRS.close();
dataQueryPS.close();
conn.close();
}catch(Exception t){

}
}
}

------------------------------CODE----------------------------------------

Regards
Pooja D


SCJP 1.4, SCWCD 1.4
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8705
    
    6

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
Rgs
k.krishnamoorthy.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading Excel File from a POJO
 
Similar Threads
File as Attachment in J2ME client
Method keeps returning null
How to send bytearray from Servlet to Midlet application?
problem while reading data from excel sheet
mysql connectivity with jboss