你先要建excel的Odbc数据源。
try:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection conn = DriverManager.getConnection("jdbc:odbc:excel","sa","password") ;
Statement stmt = conn.createStatement() ;
ResultSet rs = stmt.executeQuery("select * form[Sheet1$]" ;
while(rs.next())
out.print(rs.getString("第一行第一列列名")) ;
try:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection conn = DriverManager.getConnection("jdbc:odbc:excel","sa","password") ;
Statement stmt = conn.createStatement() ;
ResultSet rs = stmt.executeQuery("select * form[Sheet1$]" ;
while(rs.next())
out.print(rs.getString("第一行第一列列名")) ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货