When we r doing data driven test with chkpts, i want to
insert formulae in data sheet but i didn't get. How we wil
do that plz. explain in detail.



When we r doing data driven test with chkpts, i want to insert formulae in data sheet but i didn&#..

Answer / Akshay Srivastava

In QTP, you can't directly use formulas within the test data workbooks (TDWs). Instead, you need to preprocess your data to include the calculated values before importing them into your TDW.nHere's how you can create a formula in Excel and use the results in your QTP script:
1. Create your test data with formulas in an Excel sheet.
2. Save the Excel file as a comma-separated value (CSV) or text file (TXT).
3. In QTP, import the CSV/TXT file into a TDW.
4. During scripting, you can use the `Split` function to separate values in a cell by commas or other delimiters, and perform calculations based on these values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

hi Friends ,willany body tell me what is the Scope for the automation Testing inht Future is their Or not And what is the Top Most Level in the testing section according the Pay scale

1 Answers  


now a days which one is using all companies for qtpscript a)Object Repository based script b)Descriptive program based script c)BOTH

1 Answers  


when i was doing the Flight reservation with QTP calculating the tickets i got Type mismatch: '[string: ""]' in "If cdbl(tot)=cdbl(p)*t Then" error. where I am doing the mistake Could you please tell me.

5 Answers  


Can you brief the hurdles you faced during Automation testing?

0 Answers  


How will you handle java tree in qtp?

1 Answers  


What is creation time property and how does it work?

1 Answers  


Can objects recognised without repository?

5 Answers  


How to retrieve particular cell data in excel sheet ?without importing method.

3 Answers  


suppose i login into gmail page after that i read all the messages (say 10 messages) i have to send (SAVE) the messages in Html,notepad and i have to replay(Compose) send the messages please give me the code and give mail id so that i can clear my question

1 Answers  


What is .Ini file in QTP?

3 Answers  


HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation.....

5 Answers   Polaris, Siemens,


which tpye of exceptions mostly do we face in QTP

2 Answers  


Categories