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]:
Champion Level 3You can use this to convert the numbers to strings
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqconvert/index.html
then reformat the strings so they look similar
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/format.html
and then compare the strings
https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/compare.html
