Answer / 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

Answer / raju

Log files is nothing but *.txt & *.xls files

How to read log file *.txt:
1). for ex file name is raju.txt.

set a=createobject("scripting.filesystemobject")
set b=a.opentextfile("File path",1) (1 for Reading,2 for
Writing,8 for Appending)
while b.atendofline <>true
c=b.readline
msgbox c
wend

2). for ex file name is raju.xls
datatable.importsheet "file path", Sourcesheet, destination
sheet.
msgbox datatable(column no, sheet name)


i think this is working properly
if u have any quarries please call me
9823257761, my mail id is raju.ippali@gmail.com

Answer / dinesh1433

Normaly log files are of .txt format.

so to read .txt files try using FSO (file system object)

DIFFERENT RUN MODE IN QTP..1-VERIFY MODE 2-UPDATE MODE 3- dEBUG MODE. My question is in whic sitution we use these modes Explain me with example

1 Answers  

---

What is the difference between Dim And Redim

4 Answers   Hotel Jobs, IBM, Microsoft,

---

This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?

0 Answers  

---

Can anybody send me the code to get the RO property of the active screen in QTP while running?

9 Answers  

---

When we parameterise some field ex. Textbox is there any way that we can generate a specefic number of random values (For alphabetical values if possible) instead of manually entering values in the data table

2 Answers  

---

how to change the properties of object during run time . plz give the code using flight reservation

2 Answers  

---

Can we directly automate testscripts accrdoing to requirements? WHY ?

1 Answers  

---

What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?

0 Answers  

---

I have 5 save buttons in 5 tabs . The tabs are placed one after the other. My object repository have these added as 5 save buttons with name sav1, save 2, save 3 , save 4, save 5 .all are getting highlighted from OR but they are not getting clicked. After spying each button all the properties are same except First button Index 0 html id:=btnSaveTab1 outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", Second button "html id:=btnSave "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", Third button "html id:=", outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab Fourth button "html id:=btnSave outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"" 5th button "html id:=", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">",

0 Answers  

---

How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

0 Answers  

---

can u please explain what r the challenges u faced in ur automation testing

2 Answers   Genpact,

---

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

0 Answers   SoftTech,

---