Rapise 5.7+

If you have Rapise 5.7+ use Spreadsheet.DoCompare action.

Rapise 5.6 and below

An attached file CompareSpreadsheets.js contains a function:

CompareSpreadSheets(/**string*/xls1Path, /**string*/xls2Path, /**bool*/noAssertion)

Its intention is to compare to Excel sheets. 

Usage

1. Save CompareSpreadsheets.js into the test folder 

2. Add CompareSpreadsheets.js to the test folder using 'Add File'

3. Include it into <user.js>.

 

4. And use in RVL:

or in JavaScript:

function Test(params)
{
    eval(File.IncludeOnce('%WORKDIR%/CompareSpreadsheets.js'));

    CompareSpreadSheets('UserList1.xlsx', 'UserList2.xlsx');
}

 

See also an attached full sample test /Support/Attachment/84912.aspx