如何在datagridview中显示excel

[amymin123]

public DataSet EcxelToDataGridView(string strFileName)
        {
            string conStr="Provider=Microsoft.Jet.OLEDB.4.0;"+"data source="+strFileName+";"+"Extended       Properties=Excel 8.0;";
            OleDbConnection odbcon=new OleDbConnection(conStr);
            string strExcel="";
            OleDbDataAdapter da=null;
            DataSet ds=null;//清空内存缓存
            strExcel="select * from [Sheet1$]";
            da=new OleDbDataAdapter(strExcel,conStr);
            ds=new DataSet();
           
            if(odbcon.State==ConnectionState.Closed)
            {
                odbcon.Open();
            }
            da.Fill(ds);
            odbcon.Close();
            
            return ds;     
        }

这个为什么不显示我选择的excel表


请高手指点

[wuyq11]

DataSet ds= new DataSet();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
using(OleDbConnection OleConn = new OleDbConnection(strConn))
{
OleConn.Open();
String sql = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
OleDaExcel.Fill(ds);
OleConn.Close();
}

dataGridView1.DataSource=ds.Tables[0];