How to get data from 2nd row in Excel using JDBC

**siddu** · 01-02-2013, 11:53 AM

Hi,
Here, am stucking at this point. I have an excel sheet. From this excel i need to get the data and i dont want first 2 rows data. The column names are in 3rd row and I need to select the excel at run time, but not at the time of DSN creation.
Please help on this

**foulkelore** · 01-02-2013, 04:12 PM

How about you show us the work you have done so far. Have you looked into Apache POI?

**siddu** · 01-03-2013, 07:24 AM

Thanks for your reply.
No, I didnt check with POI.

**siddu** · 01-03-2013, 07:26 AM

And am trying to create DSN at run time. I have tried with the below code. Please have a look.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
PrintWriter pw=response.getWriter();

//establish connection
String url = "jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls,*.xlsx)};DBQ=D:\\Jagadeesh\\Sample.xls";
con=DriverManager.getConnection(url,"","");

//create a statement
stmt=con.createStatement();

//execute the statement
ResultSet rs=stmt.executeQuery("select distinct id,sal,name from [Sheet1$]");
while(rs.next())
{
String did=rs.getString(1);
String name=rs.getString(2);
String date=rs.getString(3);
pw.println(did+" "+name+" "+date);
}