how to read log file using QTP??

Question Posted / radhika

3 Answers
17242 Views
AppLabs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to read log file using QTP??..

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

Is This Answer Correct ?

4 Yes

0 No

how to read log file using QTP??..

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

Is This Answer Correct ?

4 Yes

2 No

how to read log file using QTP??..

Answer / dinesh1433

Normaly log files are of .txt format.

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer