读取Excel的问题

Question

smartexcel
http://sourceforge.net/projects/smartexcel/

Answer 1

athossmth(athos) 
十分感谢你，可是我的VS.NET是2002的，我看不了啊

Answer 2

先把Excel文件读取放入一个DataSet里面
再从DataSet里取出需要的值

Answer 3

fengforever(风) 
怎么实现把Excel读取到DataSet中呢？
谢谢

Answer 4

读出来放入dataset里
public DataSet GetExcel(string Path)
  {
   //DirectoryInfo parsedirect=new System.IO.DirectoryInfo(Path);
   //FileInfo[] xlsfile=parsedirect.GetFiles("*.xls");
   OleDbConnection objConn=null;
   DataSet data=new DataSet();
   try
   {
    string strConn= "Provider=Microsoft.Jet.OleDb.4.0;" + "data source="+Path+ ";Extended Properties=Excel 8.0;";
    objConn=new OleDbConnection(strConn);
    objConn.Open();
    DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null);
    string tableName=schemaTable.Rows[0][2].ToString().Trim();
    string strSql= "Select * From ["+tableName+"]";
    OleDbCommand objCmd=new OleDbCommand(strSql, objConn);
    OleDbDataAdapter sqlada=new OleDbDataAdapter();
    sqlada.SelectCommand=objCmd;
    sqlada.Fill(data,"BuyPrice");
    objConn.Close();
   }
   catch
   { 
    objConn.Close();
    throw;
   }
   return data;
  }