如何打开一个Excel文件？

Question

import java.io.*;
import java.sql.*;
    public class ExcelReadTest{
         public static void main(String[] args){
         Connection connection = null;
             try{
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con = DriverManager.getConnection( "jdbc:odbc:XLS" );
             Statement st = con.createStatement();
             ResultSet rs = st.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++) {
                     if (i > 1) System.out.print(", ");
                     String columnValue = rs.getString(i
);
                     System.out.print(columnValue);
                     }
                     System.out.println("");
                     }
                    
                     st.close();
                     con.close();
                         } catch(Exception ex) {
                         System.err.print("Exception: ");
                         System.err.println(ex.getMessage());
                         }
                         }
                    }

Answer 1

public void ReadExcel()
{
        Connection c = null;
        Statement stmnt = null;
        try
        {
            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
            c = DriverManager.getConnection( "jdbc:odbc:excel", "", "" );
            stmnt = c.createStatement();
            String query = "select project,rowno,start,end from [qas$];";
            ResultSet rs = stmnt.executeQuery( query );
            
            System.out.println( "the row list:" );
            while( rs.next() )
            {
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
                System.out.println(rs.getString(3));
                System.out.println(rs.getString(4));
            }
        }
        catch( Exception e )
        {
            System.err.println( e );
        }
        finally
        {
            try
            {
                stmnt.close();
                c.close();
            }
            catch( Exception e )
            {
                System.err.println( e );
            }
    }
}