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

why qtp supports vbscript? and not for others just like cgi,phython,shell,perl,html and all..

4 Answers   Cap Gemini,


Hi friends, I have heard that it is required to have an application hosted in the same machine where we use QTP. Otherwise QTP may identify the objects incorrectly. Please clear me is it true.

3 Answers  


what is the difference between testing and debugging?

2 Answers  


Which property will you use to check the object state? (Exist)

2 Answers   Symphony,


How can i open 5 multiple browser at once through QTP VB script

4 Answers  






how can i impliment error handling in QTP?

5 Answers   Ordain Solutions,


Suppose there is a bitmap with some text in it how do you write the script to get the text.

2 Answers   BirlaSoft,


what is the difference between window command and dialog command

1 Answers  


how to use command prompt using qtp?

8 Answers   HCL,


Which property do you use to retrieve or assign data into a cell in a Data Table object?

1 Answers  


in a web page How to check and display a particular word from a paragraph?

0 Answers  


I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”

0 Answers  


Categories