How to read data from excel into a DataSet with c#

Note you will need to install AccessDatabaseEngine.exe or AccessDatabaseEngine_x64.exe

using System.Data.OleDb;
private static DataSet getDataTableFromXLS(string xlsLocation, string sheet)
{
     DataSet ds = new DataSet();
     try
     {
          OleDbConnection oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;
          Data Source=" + xlsLocation + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");

          oledbConn.Open();
          OleDbCommand cmd = new OleDbCommand("SELECT [Username],[First],[Last name],[Email] FROM [" + sheet+ "$]", oledbConn);
          OleDbDataAdapter oleda = new OleDbDataAdapter();
          ds = new DataSet();

          oleda = new OleDbDataAdapter(cmd);
          oleda.Fill(ds);
      }
      catch (Exception ex)
      {
          logException(ex);
      }
      return ds;
}