JDBC 访问 Excel 表

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

public class ExcelReader {

    public static void main( String[] args ) {

        Connection c = null;

        Statement stmnt = null;

        try {

            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
            c = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=c:\\l_f3.201004.xlsx"); // 不设置数据源

           // c = DriverManager.getConnection( "jdbc:odbc:Book1", "", "" );

            stmnt = c.createStatement();

            //sc为要查询的sheet名字，注意格式[sc$]

            String query = "SELECT * FROM [sc$] ";

            ResultSet rs = stmnt.executeQuery( query );
            int i = 0;
            while( rs.next() ) {
             i++;
                System.out.println( rs.getString( "用户到达清单" )+i );//用户到达清单为列名

            }

        }

        catch( Exception e ) {

            System.err.println( e );

        }

        finally {

            try {

                stmnt.close();

                c.close();

            }

            catch( Exception e ) {

                System.err.println( e );

            }

        }

    }

}

文档：

http://wenku.baidu.com/link?url=4qZyfZqsNhnDzmdXE2DhTZkOjLOZEz1IivG_FkaxLRu4nsMMdw8Fp_YyKq8MKyr9Wl7iWKhoJgsGqcPYCVyL_09ecEyZiIpO_EavwNfnkjy