import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConn {
public static void main(String[] args) {
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver" ;
String dbURL = "jdbc:odbc:driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\\A.xls" ;
try {
Class.forName(driverName);
Connection connection = DriverManager.getConnection(dbURL,"","");
Statement stmt = connection.createStatement();
String sql = "select * from [sheet1$A3:S255]";
ResultSet rst = stmt.executeQuery(sql);
while(rst.next()){
System.out.println(rst.getInt(1));
}
rst.close();
stmt.close();
connection.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}