Answer Posted / jayant naikwade
Note:- Bu Using Import as well as export Method
Give path for .xls file on Root Directory in datatable
parameter as below.
p_strFile=jayant.xls
p_strFile1=jayant1.xls
strFile=DataTable("p_strFile",dtGlobalsheet)
strFile1=DataTable("p_strFile1",dtGlobalsheet)
DataTable.ImportSheet
strFile ,1 ,"acn_Dummy"
DataTable.ExportSheet strFile1 ,3
iTotalRows = DataTable.GetSheet
("acn_Dummy").GetRowCount
For i = 1 to iTotalRows
DataTable.GetSheet
("acn_Dummy").SetCurrentRow(i)
strMenuNm = trim(DataTable.GetSheet
("acn_Dummy").GetParameter("No").Value)
strAction = trim(DataTable.GetSheet
("acn_Dummy").GetParameter("name").Value)
Next
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to check bitmap output value?
What is the parameterization?
What are the different ways to invoke an application using QTP?
In an interview, what r the general questions asked in QTP? pls give me anwser to this question?
Can we create user defined functions in qtp?
Sql questions to find second max salary and how to use joins
wht type of User defined functions or Java Releated functions Do we write in VB scripting
Explain the features of quick test pro(qtp)?
how to evalute defects in QTP script?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
Which advantages helping QTP to hold the position of "Market Leader" for such a long period?
What is the difference between the design-time and run-time data tables?
What ate the Technologies supported by QTP?
What is the use of running the scripts in Hidden-mode in UFT?