Checkpoint to Excel Variable

Question

HI all!&nbsp;I am trying to find out is it possible for me to create a checkpoint that will check the highlighted text value on the webpage to a field in excel.&nbsp;&nbsp;In other words, there is a form on the site where a customer enters information which then gets passed to an API we are using. My testcase pulls values the customer enters to the fields (first name, last name) , fills in the form and then I wanted the testcase to compare passed values to excel input.&nbsp;I am using keyword test and i tried all different types of checkpoints and could not find such option.&nbsp;

tristaanogre · Answer

It's going to be a property checkpoint where you're going to check the value of the field (property name TBD).&nbsp; You'll need to write some sort of code, then, to retrieve the values from the spreadsheet and pass that in to the "Value" field in the property checkpoint.
&nbsp;
You might be able to do it using a Data Driven Loop depending upon how your code is structured.&nbsp; Or, you might need to connect with Excel via COM.&nbsp; For the data driven looping process, see&nbsp;https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/excel-storages.html and associated links.&nbsp; For using COM, see&nbsp;https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/working-via-com.html

marsha_r · Answer

It's not always obvious going through the wizard, but one you have a checkpoint set up, you can go back in to edit it and there will be one of those little ... buttons and that will let you change the comparison to Code Snippet.&nbsp; &nbsp;You can add what&nbsp;tristaanogre&nbsp;is talking about in there.

Forum Discussion

Checkpoint to Excel Variable

2 Replies

Related Content

Setting Excel filename as project variable

Specify an variable Excel file to check

Checkpoint

XML Checkpoint

Checkpoint from GUI against Excel

Recent Discussions

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons

Object Browser does not display WPF DataGridCell Border