Created By  alexey.grinevich Wednesday, August 22, 2018

Sometimes you need to compare two tables. Here we introduce a function to compare two spreadsheets.

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 https://www.inflectra.com/Support/Attachment/84912.aspx

 

 

 

 

 

 

Attachments

Selected files will be attached to any email sent on saving ticket.

file selected files selected  () Delete Selected

  • Created:
  • by:

Select files to upload

Or drag and drop files here

Uploading …
Done!
Upload More?
There was an error.
Try again?

Save to upload the selected file(s)

Article Info
  • Last Updated: 8/22/2018
  • Article ID: KB330
  • Views: 2530