Read data from Excel worksheet : Excel « Database « Java Tutorial






import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Statement stmt = DriverManager.getConnection("jdbc:odbc:employee").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();
  }
}








20.36.Excel
20.36.1.A JDBC Program to Access/Read Microsoft Excel
20.36.2.Write Data to a Microsoft Excel Spreadsheet File
20.36.3.Read data from Excel worksheet
20.36.4.Read data from Excel
20.36.5.Use JDBC ODBC bridge to read from Excel