in qtp 3 sheets is there in data table like global, action1,
action2. I want to check the rows and columns in action2.
how can check using script?

Answers were Sorted based on User's Feedback



in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and ..

Answer / prasad reddy

Hi you can check the values by mentioning the sheet name
and column name
EX:Datatable.Value("ColName","SheetName").

Thanks,
Prasad

Is This Answer Correct ?    9 Yes 3 No

in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and ..

Answer / kashinath hajare

Please check the following to check the rows and columns in
action2 or sheet2.

iTotalRowCount=DataTable.GetSheet("Sheet2").GetRowCount
For iCounter=1 to iTotalRowCount
DataTable.GetSheet("Sheet2").SetCurrentRow iCounter
value1=trim(DataTable.Value("value1","Sheet2"))
value2=trim(DataTable.Value("value2", "Sheet2"))
Next

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More QTP Interview Questions

whow much strong on VB and C?

0 Answers   UHG,


How can we use the "CreateObject("Wscript.Shell")" in QTP and what is the definition and purpose of it?

2 Answers  


How to export QTP results to an ".xls" file?

1 Answers  


please clarify the question ................. i know how to open the notepad file ? but i don't know how to enter the data into opened notepad ? Ex: set a=createobject("wscript.shell") a.run "Notepad.exe" please give the replay. my mail id is raju.ippali@gmial.com, 9823257761

6 Answers  


How many scripts do you write per day. What is the average number of scripts you have written in your recent project

1 Answers   CenturyLink, Optum, Value Labs,


What are the differences between QTP 9.2 and 10? please explain e indetail......

2 Answers   Wipro,


i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script

0 Answers  


what are the metrics in general we use in testing

1 Answers   Tanla Solutions,


When a requirement is given to u to automate , What is ur basic approach ?

4 Answers  


who will distribute the project modules for testing in testing team ?

2 Answers  


What is different command used in command Prompt while using QTP?

0 Answers  


How you calling actions in qtp?

0 Answers  


Categories