string conn = "Provider=Microsoft.Ace.OleDb.12.0;" + " Data Source='文件路径';" + "Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'"; OleDbConnection objConnection = new OleDbConnection(conn); objConnection.Open(); OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [sheet1$]", objConnection); DataSet ds = new DataSet(); myCommandd.Fill(ds, "[sheet1$]"); objConnection.Close();