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 do we analyze the checkpoint results?
What is quicktest professional (qtp window?
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
How to create Reusable and Multiple Actions?
What is the difference between run time object and test object in QTP?
after click on compose mail how can we attached a file in qtp with vbscript code
How you can delete excel file in qtp?
Mention what are the different types of recording modes in qtp? Which will be used when?
How can i check items sorted or not in a weblist ? Give me the script for this...
Hi ,Can any one pleas explain how to test splash objects using QTP?
In qtp, explain what is crypt object
Explain how you can find the absolute value of the number in qtp?
How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
What is the synchronization point in qtp?