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

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?

Question Posted / mahammad99

2 Answers
7284 Views
Polaris, I also Faced
E-Mail Answers

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

Hi Friends, I have an application that is having some options to choose. While doing business transaction I need to select one option among from available options. But here the thing is, we won't get one option which we've chosen already and the available options will get automatically from the system with time basis, moreover each and every option having with various label names respective to that option. So obviously if I run my recorded script will automatically gets fail, even though it got pass at first time. Could anyone please give me appropriate solution for this. I would be greatly obliged with you if you give the solution as soon as possible.

1 Answers Zensar,

What are the advantages of parameterization ?

0 Answers

with out object repository i need to launch IE and then navigate to a login page and then operate the objects within the page. How will be the script?

3 Answers Ordain Solutions,

How can we use regular expressions for a table in web page, each cell in table having unique identification, Now I want to count number of rows in table and enter data in all cells of the table?

1 Answers CTS,

write a test script in QTP to test the text that written in an image(i.e jpg)of a web page???

0 Answers

Please mail me the license key of QTP 9.5 t v.sadangi@gmail.com ????? thx

0 Answers

Explain sub procedure of vbscript.

0 Answers

what are the principles of good testing scripts for automation?

1 Answers

diff between wr and qtp in detail.

4 Answers

WHICH functionalities of QTP used in Banking project?