C# 中如何到入Execl表格在DataGridView 中

1、和连接SQLServer 一样，需创建连接字符串
string conn="Provioder=McrioSoft.ACE.OLEDB.12.0;Data Soucer={0}; Extended Properties=Execl 8.0;HDR=YES;IMEX=1;"//这个连接字符串比较重要，测试了好几遍才测试成功
2、创建方法
public static DataSet GetAllResult_Adapter(string sql,string patch)
{
OleDbConnection coon = new OleDbConnection(string.Format(conStr, patch)); //需要引入using system.Data.OLEDB;
OleDbDataAdapter ds = new OleDbDataAdapter(sql, coon);
DataSet dt = new DataSet();
try
{
coon.Open();
ds.Fill(dt);
return dt;
}
catch (Exception ex)
{

            throw ex;
        }
        finally
        {
            coon.Close();
        }
    }