Answer Posted / chivukula.kumar

datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")

colcount = datatable.GetSheet(k).GetParametercount
rowcount = datatable.GetSheet(K).GetParametercount
shtcount = datatable.Getsheetcount

for i = 1 to rowcount step 1
for j = 1 to colcount step 1
for k = 1 to shtcount step 1
datatable.setcurrentrow(i)
val =datatable.Getsheet(k).GetParameter(j).ValuebyRow(i)
next
next
next


Note : the above script for entire workbook values we can
get .
next

What are the steps involved in the recovery scenario wizard?

1018

---

How you can make an action as re-usable action?

1129

---

How do you test DLL files using automation Tool QTP?

3238

---

What is synchronization point in QTP?

1127

---

How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.

1933

---

Hi all can any one give me roles and responsibilities for QTP (not WINRUNNER)

3710

---

hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?

3804

---

What is the difference between Keyword Driven test and Data Driven test?

2226

---

Explain the concept of object repository and how quicktest professional recognises objects?

1023

---

How many scripts did you have?

2192

---

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?

1202

---

How to customize qtp?

1039

---

How to connect to a database?

1133

---

When to use shared and local object repository?

1078

---

How to record application running on the Virtual machine?

1094

---