DesktopapptestiOccasional ContributorJoined 3 years ago9 Posts2 LikesLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionssubitem count Hi, How do I get the count of subitem . Count of 2.1,2.2 etc as shown in the pic below. WItemCount is giving the TopITem count and not subitems. Please advise. Thank you!! SolvedRe: Row count in Excel File never mind, the excel file is corrupted. Code works fine for other excel files. Row count in Excel File Hi, Row count is always returning 8 and 4 irrespective of the data available in the excel sheet. The file has only one column and 2 rows. Excel = Sys.OleObject["Excel.Application"] Excel.Workbooks.Open("C:\\EData.xlsx") RowCount = Excel.ActiveSheet.UsedRange.Rows.Count ColumnCount = Excel.ActiveSheet.UsedRange.Columns.Count Thanks in advance. SolvedRe: reading data from Excel excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx") reading data from Excel Marsha_R Used below code to read the data from excel file and I am getting file not found error msg. def ExcelExample(): # Get the sheet of the Excel file excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx") excelSheet = excelFile.SheetByTitle["Sheet1"] # Read data from the Excel file valueA = excelSheet.Cell["A", 3].Value valueB = excelSheet.Cell[2, 3].Value valueC = excelSheet.CellByName["C3"].Value # Write the obtained data into a new row of the file rowIndex = excelSheet.RowCount + 1 excelSheet.Cell["A", rowIndex].Value = valueA excelSheet.Cell[2, rowIndex].Value = valueB excelSheet.Cell("C", rowIndex).Value = valueC # Save the file to apply the changes excelFile.Save() # Save the file with another name # excelFile.SaveAs("C:\\temp\\DataStorageExcel_new.xlsx") SolvedRe: BtnOK is not responding on click Thank you for the quick response. for one of the fields , I used keys instead of settext() and btnok responded to clickbutton() . BtnOK is not responding on click Hi Everyone, I am fairly new to TestComplete. So, I have the btnOK button on a pop up window. The object is identified and mapped correctly. The button works when I click on it manually or through keyword testing but not through script testing. ButtonOK= NameMapping.Sys.NLS.dlgTransactionEntry.Window("Button", "OK", 6) ButtonOK.ClickButton() #if ButtonOK.Exists: # ButtonOK.Keys("Space") # ButtonOK.Keys("Enter") # ButtonOK.ClickButton() # else: # Log.Message("button doesnt exists") or transaction_okay_btn = Aliases.dlgTransactionEntry.btnOK Aliases.dlgTransactionEntry.btnOK.VisibleOnScreen if (Aliases.dlgTransactionEntry.btnOK.WaitProperty("VisibleOnScreen", True, 2000)): Log.Message("button is active") transaction_okay_btn.ClickButton() I tried deleting the button and adding it again. To avoid any conflict. I used Visibleonscreen and keys(enter) as suggested in posts. Nothing works. Any suggestions would be appreciated. Thank you. Object identification issues in Desktop application Hi - Our company just bought test complete and we are trying to automate a desktop application. I am trying to identify objects that are in a table. These are dynamic objects and date changes everyday, I was able to traverse till table. But not the cell. Tried using find and findall with object identifier property and object type. I understand I have to use wildcard * in place of date. Not sure why the object is still not being identified. Below is the exact path of the cell name. It would be nice, if someone can shed some light. Thank you in Advance. Sys.Process("DesktopAppname").Window("#22770", "Find", 1).Table("Report").Row("Report Row", 13).Cell("XX-XXXXXXX - 03/14/2022") Thank you. Desktop application using python as the scripting language Hi, We are trying to automate a desktop application using python. The Desktop app is developed in Visual C++. 1. Can we use python as a scripting language ? I am guessing 'YES". Wanted to double check. 2. We have few dynamic objects and the way to use them is by ObjectIdentifier. The date in ObjectIdentifier changes every day. How to identify that object. Tried using find or findall. its not helping. Is there something in TC like contains in selenium. Also, I only see video's and information on web objects and nothing related to desktop applications. Any information is much appreciated. Thank you.