一个c#与Excel的例子

/// <summary>
  ///  将Excel中的数据读入DataSet
  /// </summary>
  /// <param name="fileName">文件路径和文件名</param>
  /// <returns>DataSet</returns>
  private DataSet ReadExcel(string fileName)
  {
   string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ fileName +";"+"Extended Properties=Excel 8.0;";
   OleDbConnection conn = new OleDbConnection(strConn);
   conn.Open(); 
   string strExcel = "";  
   OleDbDataAdapter myCommand = null;
   strExcel="select * from [sheet1$]";//从默认的sheet1表中读入数据
   myCommand = new OleDbDataAdapter(strExcel, strConn);
   DataSet ds = new DataSet();
   myCommand.Fill(ds,"Data");
   conn.Close();
   return ds;
  }