Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Syed Shameer (SyedS438)
Mphasis

Mphasis
US
SyedS438 Member since 2017 2 posts
Mphasis
Posted: Apr 1, 2017
Last activity: Apr 2, 2017
Posted: 1 Apr 2017 10:46 EDT
Last activity: 2 Apr 2017 17:38 EDT
Closed

How can we compare two excel sheets in OpenSpan

Hello Team,
I have requirement like comparing to 2 excel sheets.If the data in both the excel sheets are same then it should display a message like true.if the data is not same then it must displays a ,message false.

Please help

Thanks in Advance

To see attachments, please log in.
Low-Code App Development
Robotic Process Automation

Posted: 7 years ago
Posted: 2 Apr 2017 17:38 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

Use my Excel How To post to get the dimensions of your Excel sheets and to copy each sheet into a datatable.  Then create the following script in a script container in your project:

Call this script passing in both tables and it will return a true if they are the same and false if they are not.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice