Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String filename = "BBB";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ="+ filename);
stmt = con.createStatement();
String excelQuery = "select count(1) as A from [Counters$]";
rs = stmt.executeQuery(excelQuery);
while (rs.next()) {
System.out.println(rs.getString("A"));
}
rs.close();
stmt.close();
con.close();
转载于:https://my.oschina.net/bigsloth/blog/217809