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)

how many test scripts we will write in qtp? very urgent. please??? Thanks in advance..

1 Answers   Mind Tree,

---

what r the main attributes of test automation?

0 Answers  

---

whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

0 Answers  

---

i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji

0 Answers  

---

What is the difference between "call" and "callclose"

1 Answers   Polaris,

---

Explain the terms test and business component?

0 Answers  

---

Have you used xml check point in your project? How?

0 Answers  

---

What are the Latest Feature are added In QTP 9.2?

2 Answers   Infotech,

---

I want to assign values in a table in my software, in first column i will give values, table is of 4x4 i.e 4 row and 4 columns, i m using VBScript in my automation work. it is a simple table for giving values.

4 Answers   TCS, Wipro,

---

why require regression testing?

2 Answers   TCS,

---

How does you test a weblink which is changing dynamically?

0 Answers  

---

1. I have asked the same question for the third time, but i am getting wrong answers. Pls give me the script to count the number of edit boxes or checkboxes in an windows application screen. In windows application childobject is not working, anyone very urgent

8 Answers  

---