Read data from Excel : Excel « Database « Java Tutorial

1. Java Tutorial
2. Database
3. Excel

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class Main {
  public static void main(String[] argv) throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    ResultSet rs = DriverManager.getConnection("jdbc:odbc:employee_xls")
        .createStatement().executeQuery("Select * from [Sheet1$]");

    ResultSetMetaData rsmd = rs.getMetaData();
    int numberOfColumns = rsmd.getColumnCount();

    System.out.println("No of cols " + numberOfColumns);
    while (rs.next()) {
      for (int i = 1; i <= numberOfColumns; i++) {
        String columnValue = rs.getString(i);
        System.out.println(columnValue);
      }
    }
    rs.close();
  }
}