c# 读取excel文件第1个表的内容

private DataSet BindDsFromExcel(string strFileDir, string strDataName)     

   {           

string strConn;           

 strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileDir + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";           

OleDbConnection OleConn = new OleDbConnection(strConn);           

OleConn.Open();           

String sql = "SELECT * FROM  [" + strDataName + "$]";//如果不知道名字就用Sheets[1]            OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);           

 DataSet OleDsExcle = new DataSet();           

OleDaExcel.Fill(OleDsExcle, strDataName);           

OleConn.Close();           

return OleDsExcle; 

 }