不能高于framework 4.0
DataSet ds = new DataSet();
string filesurffix = System.IO.Path.GetExtension(sourcePath);
string strConn = "";
strConn = "Provider = Microsoft.ACE.OLEDB.12.0;" + "Data Source =" + sourcePath + ";" + "; Extended Properties = \"Excel 12.0; HDR = YES; IMEX = 1 \"";
string sql_select = "SELECT * FROM [Data$]";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
using (OleDbDataAdapter cmd = new OleDbDataAdapter(sql_select, conn))
{
try
{
conn.Open();
cmd.Fill(ds);
conn.Close();
}
catch(OleDbException e)
{
MessageBox.Show(e.Message);
return;
}
}
}