C#中EXCEL导入

#region 导入Excel数据Method2
  /// <summary>
  /// 导入Excel数据
  /// </summary>
  /// <param name="filePath">文件路径</param>
  /// <returns>dataset</returns>
  private DataSet  ImprotDataByExcel(string filePath)
  {
   OleDbConnection objConn = null;
   DataSet dataset = new DataSet();
   DataTable dt = new DataTable();
   try
   {
    //string xlsDriver = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;IMEX=1';";  
//    string connString =
//     "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E://Readme.xls;Extended Properties=Excel 8.0;";IMEX=1;
    string connString =
        "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+filePath+";Extended Properties='Excel 8.0;IMEX=1;'";
    objConn = new OleDbConnection(connString);
    objConn.Open();
    dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
    if (dt != null)
    {
     OleDbDataAdapter odda;
     string[] sheetName = new string[dt.Rows.Count];
     int i = 0;
     string singlesheetName = "";
     foreach (DataRow row in dt.Rows)
     {
      singlesheetName = row["TABLE_NAME"].ToString();
      odda = new OleDbDataAdapter("select * from [" + singlesheetName + "]", objConn);
      odda.Fill(dataset);
      dataset.Tables[i].TableName = singlesheetName.Remove(singlesheetName.Length-1,1);
      i++;
     }
     objConn.Close();
    }
   }
   catch (Exception e1)
   {
          
    objConn.Close();
    throw new Exception(e1.Message);
   }
   return dataset;
  }
  #endregion