cancel
Showing results for 
Search instead for 
Did you mean: 

Can we keep assertion data on excel file?

ccs
New Contributor

Can we keep assertion data on excel file?

I wanted to know whether it's possible to keep our assertion data (expected outcome) on excel files and use them for comparison with actual outcome data automatically?

2 REPLIES 2
ChrisAdams
Community Leader

Re: Can we keep assertion data on excel file?

Hi,

 

Not automatically, but it can be done and is something I do on a daily basis.

 

If you're using Excel, you need to first look at Data-Driven tests (https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/index.html).  With a data-driven test, each row represents some test and the parameters for the test are the columns.  In each row, I also includ the expected result values I want to test.  Then when the test runs (for each row) the data is used in calling some web service, I then use assertions to check the returned values against my expected results.

ZDGN
Contributor

Re: Can we keep assertion data on excel file?

Hi @ccs,

 

Of course you can !

You'll need some script to get your data from your Excel file.
But then you'll be able to extracted value to perform your assertion.

Tell us if you need more explaination 😉

 

David.

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors