Answer / uday kumar_anem

Here i am sharing a small snippet script, to import the
data from Excel sheet to QTP during runtime and using the
values.

I have an Excel sheet which contains OrderNumber column and
its values. After that i am displaying the order numbers in
excel during runtime.

datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
datatable.GetSheet(1)
rowCount=datatable.GetRowCount
For i=1 to rowCount
datatable.SetCurrentRow(i)
val=datatable.Value("OrderNumber","Global")
msgbox(val)
Next

Answer / yusuf

The problem is not about import it is about EXPORT. I have
the same problem;
I add a new sheet to datatable and add new parameters then I
try to go and set second rows values but I can't go second
row. So I could EXPORT only one row from datatable.

Is there any suggestion about this problem?

Thanks.

Answer / hatim

Hi,
instead of reinventing the wheel try the QTP import method

like this

DataTable.ImportSheet "C:\name.xls" ,"srcSheetname or index
" ,"type your dist data table sheet name here"

Answer / ramu

by using the method of

dataTable.importsheet(filename,sheetsource,sheet dest)

Answer / kishore

U can use the below code to load the Excel to QTP
Dim App 'As Application
Set App = CreateObject("QuickTest.Application")
App.Test.Settings.Resources.DataTablePath ="datatablepath"

Answer / srini

code reads the 4 rows in the sheet ok, but does it 5 times?
It doesn't sound like closing the datasheet is the problem

how to close the datasheet runtime ?

Answer / sridatta

Dim i,row
row=datatable.getsheet("YOURSHEET").GetRowCount
for i=1 to row
datatable.getsheet("YOURSHEET").SetCurrentRow(i)
<---Do your Operation-->
This code will word

Answer / 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

Answer / sridatta

DataTable.Addsheet("Destination")
DataTable.ImportSheet "c:\path.xls","source","destination"
row=datatable.getsheet("Destination).getrowcount
for i=1 to row
datatable.SetCurrentRow(i)
val=datatable.Value("path","Global")
msgbox(val)
Next

Answer / jay desai

When you are importing an excel sheet into QTP, the
datatable defaults to the first row. Below is an example
that will help you importing all the data into QTP.

Dim jj,Rows
Rows=DataTable.LocalSheet.GetRowCount
For jj=1 to Rows
DataTable.LocalSheet.SetCurrentRow(jj)
.......
<Perform your operation>
.......
Next

'I hope the above code will work.

How do you invoke any application and write a script to invoke QTP using VB Script.

2 Answers   HealthAsyst,

what is the frame work your using in automation testing

2 Answers  

Can U Explain about QTP tool from older version to latest version also its differences?

0 Answers  

General Ques : At What State u start Automating ? means at what stage we start writing QTP scripts ?

2 Answers  

What is the difference between Client/Server application and Web application ?

2 Answers   ArisGlobal,

In qtp,how to interact tool & application build?

1 Answers  

How can we parameterize our test, values in flat file. Ex:- Values in notepad, with that values i want to parameterize the test.

3 Answers   Ordain Solutions,

dar Sir I am Facing th eProblem in QTP thet ,when I start thrcording inthe QTP for the ASP front end and C# the Coding Language I fing that recording is Done well for the Login screen but at the Time Running the script the QTP is Unable to Identify the Objects On the Objec Onht eLigin screen .Please answer the Question in Description and the Propables reason I might be facing alsp the Popable solution I have to Take thanks and ragards

1 Answers  

What are the differences between table and db checkpoints?

0 Answers  

I have written some scripts in QTP by using older version, but I want to run them in latest version. Is there any process to do that.If so can anyone explain me?

1 Answers  

Hi,will U Please Provide me details certification for QTP &QC and also please provide me the Material also. Send to mail:jjaanu2mail@gmail.com

0 Answers  

i want to learn testing tools what i have to know before.iam fresher i dnt know any this..which langagues i have to before testing.

2 Answers   Wipro,