excel数据导入到dataset代码

excel数据导入到dataset代码

public dataset execleds(string filenameurl, string table)
  {
  string strconn = "provider=microsoft.jet.oledb.4.0;" + "data source='" + filenameurl + "';extended properties='excel 8.0; hdr=yes; imex=1'";
  oledbconnection conn = new oledbconnection(strconn);
  conn.open();
  dataset ds = new dataset();
  oledbdataadapter odda = new oledbdataadapter("select * from [sheet1$]", conn);
  odda.fill(ds, table);
  return ds;
  }
  select * from opendatasource('microsoft.jet.oledb.4.0','user id=admin;password=;data source=filenameurl;extended properties=''excel 8.0;imex=1''')...sheet1$