ExcelDataReader

 using ( var stream = File . Open ( filePath , FileMode . Open , FileAccess . Read ) )
{
    // Auto-detect format, supports:
    //  - Binary Excel files (2.0-2003 format; *.xls)
    //  - OpenXml Excel files (2007 format; *.xlsx, *.xlsb)
    using ( var reader = ExcelReaderFactory . CreateReader ( stream ) )
    {
        // Choose one of either 1 or 2:

        // 1. Use the reader methods
        do
        {
            while ( reader . Read ( ) )
            {
                // reader.GetDouble(0);
            }
        } while ( reader . NextResult ( ) ) ;

        // 2. Use the AsDataSet extension method
        var result = reader . AsDataSet ( ) ;

        // The result of each spreadsheet is in result.Tables
    }
}

 var reader = ExcelReaderFactory . CreateReader ( stream , new ExcelReaderConfiguration ( )
{
    // Gets or sets the encoding to use when the input XLS lacks a CodePage
    // record, or when the input CSV lacks a BOM and does not parse as UTF8. 
    // Default: cp1252 (XLS BIFF2-5 and CSV only)
    FallbackEncoding = Encoding . GetEncoding ( 1252 ) ,

    // Gets or sets the password used to open password protected workbooks.
    Password = "password" ,

    // Gets or sets an array of CSV separator candidates. The reader 
    // autodetects which best fits the input data. Default: , ; TAB | # 
    // (CSV only)
    AutodetectSeparators = new char [ ] { ',' , ';' , ' \t ' , '|' , '#' } ,

    // Gets or sets a value indicating whether to trim white space values for CSV (Default 'true').
    // (CSV only)
    TrimWhiteSpace = true ,

    // Gets or sets a value indicating whether to leave the stream open after
    // the I ExcelDataReader object is disposed. Default: false
    LeaveOpen = false ,

    // Gets or sets a value indicating the number of rows to analyze for
    // encoding, separator and field count in a CSV. When set, this option
    // causes the I ExcelDataReader .RowCount property to throw an exception.
    // Default: 0 - analyzes the entire file (CSV only, has no effect on other
    // formats)
    AnalyzeInitialCsvRows = 0 ,
} ) ;

 var result = reader . AsDataSet ( new ExcelDataSetConfiguration ( )
{
    // Gets or sets a value indicating whether to set the DataColumn.DataType 
    // property in a second pass.
    UseColumnDataType = true ,

    // Gets or sets a callback to determine whether to include the current sheet
    // in the DataSet. Called once per sheet before ConfigureDataTable.
    FilterSheet = ( tableReader , sheetIndex ) => true ,

    // Gets or sets a callback to obtain configuration options for a DataTable. 
    ConfigureDataTable = ( tableReader ) => new ExcelDataTableConfiguration ( )
    {
        // Gets or sets a value indicating the prefix of generated column names.
        EmptyColumnNamePrefix = "Column" ,

        // Gets or sets a value indicating whether to use a row from the 
        // data as column names.
        UseHeaderRow = false ,

        // Gets or sets a callback to determine which row is the header row. 
        // Only called when UseHeaderRow = true.
        ReadHeaderRow = ( rowReader ) => {
            // F.ex skip the first row and use the 2nd row as column headers:
            rowReader . Read ( ) ;
        } ,

        // Gets or sets a callback to determine whether to include the 
        // current row in the DataTable.
        FilterRow = ( rowReader ) => {
            return true ;
        } ,

        // Gets or sets a callback to determine whether to include the specific
        // column in the DataTable. Called once per column after reading the 
        // headers.
        FilterColumn = ( rowReader , columnIndex ) => {
            return true ;
        }
    }
} ) ;

 var result = reader . AsDataSet ( new ExcelDataSetConfiguration ( )
{
    ConfigureDataTable = ( tableReader ) => new ExcelDataTableConfiguration ( )
    {
        FilterRow = ( rowReader ) => {
            int progress = ( int ) Math . Ceiling ( ( decimal ) rowReader . Depth / ( decimal ) rowReader . RowCount * ( decimal ) 100 ) ;
            // progress is in the range 0..100
            return true ;
        }
    }
} ) ; 

 string GetFormattedValue ( I ExcelDataReader reader , int columnIndex , CultureInfo culture )
{
    var value = reader . GetValue ( columnIndex ) ;
    var formatString = reader . GetNumberFormatString ( columnIndex ) ;
    if ( formatString != null )
    {
        var format = new NumberFormat ( formatString ) ;
        return format . Format ( value , culture ) ;
    }
    return Convert . ToString ( value , culture ) ;
}

 var result = reader . AsDataSet ( new ExcelDataSetConfiguration ( )
{
    ConfigureDataTable = ( _ ) => new ExcelDataTableConfiguration ( )
    {
        UseHeaderRow = true
    }
} ) ; 

 System . Text . Encoding . RegisterProvider ( System . Text . CodePagesEncodingProvider . Instance ) ;