using System.Data.OleDb;
using System.IO;

public class ExcelClass
{
    private string _caminho;
    private string _StringDeConexao;
    public string Caminho
    {
        get
        {
            return _caminho;
        }
        set
        {
            _caminho = value;
        }
    }
  
    public ExcelClass()
    {
   
    }
    public DataSet DsExcel(string _query)
    {
     _StringDeConexao = @"Provider=Microsoft.Jet.OLEDB.4.0;";
     _StringDeConexao += "Data Source=" + _caminho + ";";
     _StringDeConexao += "Extended Properties='Excel 8.0;HDR=YES;'"; 
        using (OleDbConnection _cn = new OleDbConnection(_StringDeConexao))
        {
            _cn.Open();
            OleDbDataAdapter _adapter = new OleDbDataAdapter(_query, _cn);
            DataSet ds = new DataSet("EXCEL");
            _adapter.Fill(ds);
            return ds;
        }
    }
}