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)

tell me about regular expressions in QTP? where we use? give eample?

2 Answers   IBM,

---

Write Descriptiv prg 4 login logn....txt bx password---txt bx ok---btn

2 Answers   Hewitt,

---

A web Page has a webtable with four columns and four rows. The first column is of ID and has values of 100,100A,A100,100y Find out the number of rows whose ID starts with 100. Similarly the last column is 'number of links'. Each row in the last column has values like link1,link2,link3 etc Find out the number of links where id is 100

1 Answers   Virtusa,

---

Explain different type of event trigger option.

0 Answers  

---

Which object repository we use in real time and can we merge 2 object repostiory and how?

6 Answers   HCL, Satyam,

---

What is Curd testing?

0 Answers   Wipro,

---

i'm using QTP 8.2, How should i select(browse) object repository from desktop(or from local local drives like C:\,D:\)?. Note:- object repository to select(browse) is been sent by some other person who is using QTP 9.0

1 Answers  

---

how do find current links in webpage for ex: in yahoowebsite today mainpage is having 50 links and next day same page is having 60 links. if i run same programe it should display total links in webpage ?

4 Answers   CTS,

---

How to check bitmap output value?

0 Answers  

---

Explain how Selenium is different from UFT?

0 Answers  

---

pls help me with scripting,right from the beginning in QTP

1 Answers  

---

Explain process of smart Identification in QTP?

0 Answers  

---