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.

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

External table is not in expected format

Unexpected dialog is not handled by event handler

how to run custom scripts after project suite Run is completed

Testing a Citrix application via Citrix Viewer and the IQ module

Bypassing TC engine