string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Path\\FileName.xls;Extended Properties=Excel 8.0;";
OleDbConnection conxls = new OleDbConnection(mystring);
string sql = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conxls);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
转载于:https://www.cnblogs.com/dqhhdong/archive/2008/10/22/1316613.html