I am using excel sheet to export data to QTP but it
selects just one row of data from excel sheel how to import
all rows of excel sheet to QTP during runtime
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 19 Yes | 2 No |
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.
Is This Answer Correct ? | 7 Yes | 1 No |
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"
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ramu
by using the method of
dataTable.importsheet(filename,sheetsource,sheet dest)
Is This Answer Correct ? | 7 Yes | 4 No |
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"
Is This Answer Correct ? | 5 Yes | 3 No |
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
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 1 No |
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
Is This Answer Correct ? | 1 Yes | 1 No |
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.
Is This Answer Correct ? | 7 Yes | 9 No |
when we open flight reservation.at that time where we found synchronization point() and wait function().i m confused .i want this answer.
It is given in the help of QTP 9.2 that we cant debug the scripts. Is there any other way to VIEW, PAUSE and make modifications in the scripts during execution???
On what basis we select test cases to automate?
When we r doing data driven test with chkpts, i want to insert formulae in data sheet but i didn't get. How we wil do that plz. explain in detail.
QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?
How many types of recording facility are available in quicktest professional?
GET WHETHER THE GIVE NUMBER VALID OR NOT IN BETWEEN THE GIVEN RANGE?IN VB SCRIPT(QTP)
How many types of recording modes in the qtp?
What is smart identification?
Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???
Explain the features of quick test pro(qtp)?
Whether it is possible to test the adobe's controls like zoom, resize, save etc using QTP...If yes, how u can do the same?