Read data from Excel worksheet Let's assume we have a worksheet like this LASTNAME FIRSTNAME ID Reiser Beth 102 Ricci Dylan 111 Gugliuzza Brian 116 To access this data, we can use the JDBC-ODBC bridge. Microsoft provides an ODBC driver to Excel worksheet. Define an ODBC datasource (system DSN) named "employee_xls" that points to that worksheet. import java.io.*; import java.net.*; import java.sql.*; import java.util.*;public class EmployeeReader{ public static final String DRIVER_NAME = "sun.jdbc.odbc.JdbcOdbcDriver"; public static final String DATABASE_URL = "jdbc:odbc:employee_xls"; public static void main(String[] args) throws ClassNotFoundException, SQLException{ Class.forName(DRIVER_NAME); Connection con = null; try { con = DriverManager.getConnection(DATABASE_URL); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery ("select lastname, firstname, id from [Sheet1$]"); while (rs.next()) { String lname = rs.getString(1); String fname = rs.getString(2); int id = rs.getInt(3);
Let's assume we have a worksheet like this LASTNAME FIRSTNAME ID
Reiser Beth 102
Ricci Dylan 111
Gugliuzza Brian 116
To access this data, we can use the JDBC-ODBC bridge. Microsoft provides an ODBC driver to Excel worksheet.
Define an ODBC datasource (system DSN) named "employee_xls" that points to that worksheet. import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;public class EmployeeReader{
public static final String DRIVER_NAME =
"sun.jdbc.odbc.JdbcOdbcDriver";
public static final String DATABASE_URL = "jdbc:odbc:employee_xls"; public static void main(String[] args)
throws ClassNotFoundException, SQLException{
Class.forName(DRIVER_NAME);
Connection con = null;
try {
con = DriverManager.getConnection(DATABASE_URL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery
("select lastname, firstname, id from [Sheet1$]");
while (rs.next()) {
String lname = rs.getString(1);
String fname = rs.getString(2);
int id = rs.getInt(3);
System.out.println(fname + " " + lname + " id : " + id);
}
rs.close();
stmt.close();
}
finally {
if (con != null)
con.close();
}
}
}