Contributions
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.Solved608Views1like1Comment- 729Views0likes0Comments
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")Solved760Views0likes3CommentsBtnOK 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.675Views0likes2CommentsObject 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 withobject 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.378Views0likes1CommentDesktop 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 inObjectIdentifier 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.428Views0likes1Comment