Forum Discussion
JackSparrow
9 years agoFrequent Contributor
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)
- joseph_michaud9 years agoModerator
The example is creating folders in the log file called Record: 0, Record: 1, etc.
Expand the folders to see the values.
- JackSparrow9 years agoFrequent Contributor
joseph_michaud thanks for the info which location it will create the folder and details.
- joseph_michaud9 years agoModerator
The folders are logical constructs. (They are implemented as different node types in the log file.)
To see the folder contents click on the 'plus' to the left of the line in the TestComplete Test Log.
Related Content
- 7 years ago
- 8 years ago
Recent Discussions
- 52 minutes ago
- 15 hours ago
- 7 days ago
- 10 days ago