hxiao
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Add testcases to Testcomplete test items automatically
Hi, I search in the Testcomplete documents for automatically adding test scripts to Testcomplete test items list, then after the whole bunch of testcases finished, I can get a summary about the each test's result. Is there a way to add test script to test items through script? Thanks1.1KViews0likes2CommentsChrome login button press down in the script but didnot open the next page
Hi, I have a simple login screen, user and password, login button, I run same test case on IE, firefox and edge, the next page can open successfully after I input user, password then press login. However when I run it for chrome, the next page cannot open, it still stay in the login page with user input and password input empty. any idea, thanksSolved1.3KViews0likes3CommentsRe: How to select Excel sheet in python?
Hi NisHera, Thank you for your reply. Actually I have tried the same thing, but it didnot work. The error is "The specified object is not callable." I also tried : sheet = Excel.Workbooks.open(file).Sheets["Sheet1"], the error is "The specified object is not indexable." so it must be some special way in python to select sheet.23KViews0likes0CommentsHow to select Excel sheet in python?
Hi, From https://support.smartbear.com/viewarticle/69443/#_ga=1.128686159.2137448148.1449520310 I have python code to read Excel file: def ReadDataFromExcel(): Excel = Sys.OleObject["Excel.Application"] Excel.Workbooks.Open("C:\\Work\\TestBook.xls") RowCount = Excel.ActiveSheet.UsedRange.Rows.Count ColumnCount = Excel.ActiveSheet.UsedRange.Columns.Count for i in range(1, RowCount + 1): s = ""; for j in range(1, ColumnCount + 1): s = s + VarToString(Excel.Cells.Item[i, j]) + '\r\n' Log.Message("Row: " + VarToString(i), s); Excel.Quit(); However I didn't find API how to select a sheet for multiple sheet Excel file? Please advice. Thanks HeatherSolved24KViews0likes8Comments