compare with web page's table and excel's table.

Question

Hello. I wonder that Test Complete Keywordtest can compare web page's table and excel file's table?

I need this process.

first, I have a excel file. (that file contains web page's table information)

second, When I execute the web page the table(grid) comes out on the web page.

Then, I compare with excel file and web page's table information.

I have to check whether the information in the Excel data and the web page's table matches.

in test complete keywordtest, is that possible?

marsha_r · Answer

You can use this to convert the numbers to strings
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqconvert/index.html
&nbsp;
then reformat the strings so they look similar
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/format.html
&nbsp;
and then compare the strings
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/compare.html
&nbsp;

marsha_r · Answer

What I would do is store them both as DBTables and then compare those two tables.
&nbsp;
https://support.smartbear.com/testcomplete/docs/reference/project-objects/items/stores/dbtable/index.html
https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html
&nbsp;
https://support.smartbear.com/testcomplete/docs/reference/project-objects/items/stores/dbtable/compare.html

egg · Answer

Thanks your answer.&nbsp;But I wonder it only must use the Script(java script or program language)?&nbsp;Can't I use keywordtest?&nbsp;&nbsp;&nbsp;

marsha_r · Answer

In a keyword test, you can use Run Code Snippet to put in a short piece of script.

angelina · Answer

I need to compare Web table with downloaded excel file. Excel data have numeric value which is formatted in excel (example 523010735055.256 formatted to in excel $ 523,011. I need to validate $ 523,011 with UI value. How can I do equal both the table. Image for reference [1]:

Forum Discussion

compare with web page's table and excel's table.

6 Replies

Related Content

Compare logos on pages

compare Excel files:

Need help comparing orderID on a second page

Comparing table data in IF not working

Comparing Excel files - Can't find file

Recent Discussions

Testing Blazor in WPF on Desktop?

Error The Application Frame Host process is not running.

Overwriting Files with aqFile.WriteToTextFile

Object Recognition different during recording on VM

secure channel support error while runnning API code