using Microsoft.Office.Interop.Excel; using System.Data.OleDb;

public DataSet seachExcel(string str) //參數為excel的路徑  {    OleDbDataAdapter da = new OleDbDataAdapter();    DataSet ds = new DataSet();    DataTable dt = new DataTable();    string NameTable = "";    string ConText = "";    try    {      //獲取Excel路徑      FileInfo info = new FileInfo(str);      //獲取文件的擴展名      string fileExt = info.Extension;      //判斷用哪種連接方式      if (fileExt .ToLower() ==".xls")      {        ConText = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str + ";Extended Properties='excel 8.0;hdr=no;IMEX=1';Persist Security Info=false";      }      else if (fileExt.ToLower() == ".xlsx")      {        ConText = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + str + ";Extended Properties='excel 12.0 Xml;hdr=no;IMEX=1';Persist Security Info=False";      }      //連接excel      OleDbConnection conn = new OleDbConnection(ConText);     //打開excel      conn.Open();      dt=conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null );        if(dt!=null && dt.Rows .Count >0)        {          //獲取sheet1表單的表名          NameTable = dt.Rows[0]["TABLE_NAME"].ToString();          //獲取sheet2表單的表名          //NameTable = dt.Rows[1]["TABLE_NAME"].ToString();        }        string sql = "select * from [" + NameTable + "]";        da = new OleDbDataAdapter(sql, conn);        try        {          da.Fill(ds,NameTable); //把數據填充到Dataset        }          catch        { }        conn.Close();    }    catch    {    }    return ds; //反回Dataset}

string strDataPathPhy = "c://1.xls";string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + strDataPathPhy + ";Extended Properties=Excel 8.0";OleDbConnection myConn = new OleDbConnection(strCon);string strCom = " SELECT * FROM [Sheet1$]";myConn.Open();OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);DataTable dtData = new DataTable();myCommand.Fill(dtData);myConn.Close();