c#读取Excel文件

    private DataTable CallExcel(string filepath)
    {
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;");
        con.Open();
        DataTable schemaTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
        //ArrayList lis = ExcelSheetName(schemaTable);
        DataRow dr = schemaTable.Rows[0];
        //取得sheet名Rows[i][1]
        string kk = dr[2].ToString();
        kk = Convert.ToString(kk);
        string tableName = schemaTable.Rows[0][2].ToString().Trim();

        string sql = "select * from [" + kk + "]";//选择第一个数据SHEET
        OleDbDataAdapter adapter = new OleDbDataAdapter(sql, con);
        DataTable dt = new DataTable();
        adapter.Fill(dt);
        con.Close();
        con.Dispose();
        return dt;
    }