【www.gdgbn.com--excel】

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$

本文来源：http://www.gdgbn.com/bangongshuma/25446/