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.

Please any on explain usage of "on error resume next","On error goto 0" with sample code....Thankyou......... when a tester is asked to execute 100 scripts in a short time..(the server will be down in another 10 min)..how he has to run those scripts?

2 Answers   Datamatics,

In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field will reflects and so on.if total psngrs=100 then will we capture all the fields for the psngrs to Automate the app how we can handle this scenerio thru Descriptive programming?

0 Answers  

requirement is for combo box your expected value is str= "Denver.Frankfurt.London.Los Angeles.Paris.Portland.San Francisco.Seattle.Sydney.Zurich" you must get the text in combo box and need to compare them how

0 Answers   FIS,

what are the different data driven types?

6 Answers  

Hi, Any one have the crack for QTP 10.0,if so could you please send it to phanijuly10@gmail.com

2 Answers  

Any one please tell me how to create framework in QTP (in detail). Is there any website for reference?

1 Answers  

what do you call the window testdirector-testlab?

1 Answers  

In QTP TEST DIRECTOR COMBINATION WHAT IS THE PURPOSE OF TEST DIRECTOR? In Somebody says to store test cases and design test cases.?ok fine , but In test director 5.0 , QTp not launching. what u do?

0 Answers  

Is there anyway to have QTP go into a website and map out every object before I actually record any tests? I basically want to map out a website with all the objects and build a complete repository. The reason is because I'm running into issues with hierarcical objects. for example: Browser("ABC company- Home").Page("ABC company - Home").Link ("About Us").Click Browser("ABC company - Page 2").Page("ABC company - Page 2").Link("About Us").Click Both these links ("objects" and I use that term loosely as I'm trained mostly in OO programming) go to the same place but but the object heirarchies (pages) are different. I want a repository that will find any possible link on any possible page without having to manually record it. Is there a way to do this?

1 Answers  

Hi cud you plz answer my question.. what is the size of Object Repository?

8 Answers   TCS,

what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com

0 Answers   EpuraTech,

Explain different recording modes?

0 Answers