Hi, This is the first time I’ve tried this so I’ll attempt to explain it as best I can: We run an overnight webjob that create new billings which is then output into excel and saved locally. What I need to be able to do is compare yesterdays excel file with todays file and check for differences i…

hello, read both files row by row to list and compare then results here some where to start https://www.codejava.net/coding/how-to-read-excel-files-in-java-using-apache-poi

hi @kazurayam I guess this Winmerge use is not easy to automate

As you know, we can invoke any command in the commandline from Katalon’s TestCase script: [image] Execute Windows commands To execute Windows command line, simply use this script in your test case: String cmd = And WinMerge has the Commandline Mode: https://man…

Thanks both, I will update if I run into any issues along the way but thanks for the help.

Hello, I did some playing with this… something like this way TESTCASE: import static com.kms.katalon.core.checkpoint.CheckpointFactory.findCheckpoint import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase import static com.kms.katalon.core.testdata.TestDataFactory.findTestData i…

Comparing 2 Excel Files for differences

Web Testing

kazurayam October 13, 2020, 6:12pm 3

I would use WinMerge with xdocdiff plugin

http://freemind.s57.xrea.com/xdocdiffPlugin/en/index.html

Capture chrome console logs and network when i run my test suite and validate downloaded excel sheet

Topic		Replies	Views
Compare .xls files Web Testing katalon-studio	1	506	October 26, 2020
Compare Csv file Web Testing katalon-studio	26	3742	August 13, 2020
Read Write Excel Custom Keywords Miscellaneous custom-keyword	78	13831	March 26, 2024
Visual Inspection of Excel and PDF Tips and Tricks katalon-studio , tips-tricks	1	2083	May 2, 2023
Posibble to store all data under one excel sheet? API Testing katalon-studio , api-testing	22	2331	February 6, 2020

Comparing 2 Excel Files for differences

Related topics