adspace


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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?

1307


Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com

2485


i need qtp tutorial. pls send it to sridhar.k151@g mail.com

2183


we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?

2156


Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ

2123


write script for bitmap image?

2124


What is the new version of qtp which is recently released in the market?

1168


Hi, how can we check or avoid the memory leakage in QTP9.2?

2181


Can you brief the hurdles you faced during Automation testing?

1147


i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com

1956


can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1878


hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

2440


any body can you help me what is the script to automate an comand promt

2577


any body plz send health care domain project to me with explanation any two modules on that project. mail_id: ranjith_99reddy@yahoo.co.in

3958


Hi friends did any budy attend accenture system test for qtp? if any budy pls drop questions.not only accenture any other mnc company which you attended system test(QTP)?it may helpful to others also

2406