Forum Discussion

RD_TestComplete's avatar
RD_TestComplete
New Contributor
11 years ago

How to compare object (e.g text box, label) value with excel sheet cell value?

Hi Tea,   I have one text box in Qlikview report which shows sum of Yearly Budget. I have separate excel sheet which also one of the data source for my report. I want to configure the test case in ...
Colin_McCrae's avatar
Colin_McCrae
Community Hero
11 years ago

?!?!

 

Thats a pretty high level question!

 

It pretty much reads as .... "Please write my test for me"!

 

How far have you got? Are you familiar with testcomplete? Are you scripting or keyword?

 

I can't see you getting much useful information with such a high level request. Best I can do for you just now is point you towards the support pages for working with Excel: https://support.smartbear.com/viewarticle/74555/

 

As for your application .... you haven't provided nearly enough information to get anything useful back ....

RD_TestComplete's avatar
RD_TestComplete
New Contributor
11 years ago

Thanks for your reply

 

Yes , I know that this is weird question. sorry about this. I am novice user of test complete

 

I am not asking for complete code but just need guideline

 

So my requirement is -

 

I am trying to implement the test case for my Qlikview report (If you know Qlikview) It’s a report/dashboard which we can open from browser (e.g. ap-b.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FItalian Schools Navigator.qvw&host=demo11)

 

The report has one table which has value in tabular format. I want to compare this table data with excel sheet (excel sheet has exact columns and rows) using testcomplete

 

Now I have tried  -

  • keyword testing and added the data Object point but I don’t know how to loop though the excel sheet and web table data to compare the values
  • Script test and added EXCEL DDT driver but it’s not recognize the table data (giving data in one stream in single string object)

 

Could you please assist?