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.

hi friends i was tried to connect qtp with oracle database using provider.i got a error.so anyone can help me out by correct script

2 Answers  

Expalin Text/Text Area Checkpoint

1 Answers   Crea,

In an interview what r the questions asked in qtp related project? pls any answer this question?

3 Answers  

Which Databases supports for QTP?

2 Answers  

How do u do batch testing in WR & is it possible to do in QTP, if so explain?

1 Answers   Crea,

I am verifying the actual vs the input value to make sure that they been entered correctly. In the Global Sheet I have a column called Customer with the multiple names in each row and now I am trying to capture the value during runtime under the column name Customer_in_Apps. Somewhat it works but during runtime the values are being stored in each column vs each row i.e., Customer_in_Apps, Customer_in_Apps1. Automatically it add columns instead of rows. row=datatable.getsheet("Global").GetRowCount for x=1 to row datatable.getsheet("Global").SetCurrentRow(x) Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Val1=Datatable.Value("Customer",dtGlobalSheet) Val2 = Datatable.GlobalSheet.AddParameter("Customer_in _Apps",runtimevalue) If (trim(Val2)=trim(Val1)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &_Val2 else Reporter.ReportEvent micFail, "Customer validation unsuccessful", "Actual Value: " &Val1&vbcrlf& "Customer Value: " &Val2 End If Next

3 Answers  

Hi..All I have installed QTP 10.0, and need to Automate SAP Application.....so i need to Install SAP Add-ins, anybady has SAP-Addins, Please help me, and thanks in advanced plese send it on my email id: sandipgami84@gmail.com Thanks, Sandip Gami +91-9714177088

1 Answers  

what is the data driven testing?

0 Answers  

What are "Ordinal Identifiers" and where it is used in QTP. AS FAR AS i KNOW, its is used to identify the object. but i want clarity regarding this.

2 Answers  

How to insert a check point to a image to check enable property in QTP?

1 Answers  

Hi, I Would Like to Know which is the Best QTP Certification Training Institute in Hyd? Thanks in Advance kishan

1 Answers  

what is option explicit?

5 Answers