The example is creating folders in the log file called Record: 0, Record: 1, etc.
Expand the folders to see the values.
And i have Tried otherway to get the data but am facing the Python Run-time Error method cannot be callable
def ReadDataFromExcel():
xl = Sys.OleObject["Excel.Application"]
book = xl.Workbooks.open("C:\\DriverSheet.xls")
TCSheet = book.Worksheets("TestCases")
#TCSheet = WorkBook.worksheets("TestCases")
TSSteps = book.Worksheets("TestSteps")
TCRows = TCSheet.UsedRange.Rows.Count
for i in range(2,TCRows):
if TCSheet.cells(i,2).Value == "Yes":
SlNo = TCSheet.cells(i,1).Value
Module = TCSheet.cells(i,2).Value
TestCase = TCSheet.cells(i,3).Value
Duration = 0
TSRows = TSSheet.UsedRange.Rows.Count
for j in range (2,TSRows):
if((TSSheet.cells(j,1).Value == TestCase) and ( TSSheet.cells(j,4).Value == "Yes")):
Flag = Flag+1
if Flag ==1:
Report.CreateTestCaseReportHeader(TestCase)
TSCols = TSSheet.UsedRange.Columns.Count
TSData = ""
for k in range (5 , TSCols):
TSData = TSData & TSSheet.cells(j,k).Value & ";"
Parameter = Split(Tsdata,";")
BeforeTime = aqDateTime.Time()
Execute.TSSheet.cells(j,3).value
AfterTime = aqDateTime.Time()
Duration = Duration + aqDateTime.TimeInterval(AfterTime,BeforeTime)