jpolvino
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Reading long int from Excel, showing up in TC as a float
TL;DR I want to get exactly what appears in the Excel cell. I have code that reads a number of fields from an Excel file. At least a few of the fields have integers with a large number of digits, and they are coming over as floats. excelFileAbsolutePath = "\\\\path\\to\\file\\input.xlsx" excelFile = Excel.Open(excelFileAbsolutePath) excelSheet = excelFile.SheetByTitle[worksheetName] worksheetObjValue = excelSheet.Cell[2,2].Value In cell 2,2 Excel has the value 20220829. When I debug the Python script, it is showing up as 20220829.0. I tried casting to str, but all that does is make it "20220829.0" I even tried on the Excel side to format the column to be text and that had no impact. So far, the workaround I found is to set the cell in Excel to be something like ="20220829" but that is awfully kludgy IMHO. Is there a way to get the text of the cell, as opposed to the value? I recall VBA had methods to get the bare text for this reason, but I am not aware of an analogous method through TestComplete. Doing Python magic, such as trimming off the ".0" at the end is not preferable because some of my data may legitimately want those characters. Thanks!Struggling with handing an object if it exists, and ignoring it if it doesn't
I have a web page (non-mobile) that I'm trying to test, and it sometimes has a button that needs to be pressed. I'd like to have python code that works like "if the button exists, press it, otherwise just proceed." No errors needed, just that logic. The button (when it exists) is here: Aliases.browser.pageName.formAspnetform.submitbuttonDelete I've tried using WaitElement: btnExists = True if Aliases.browser.pageName.formAspnetform.WaitElement(submitbuttonDelete,5).Exists else False I've tried CheckProperty: btn = aqObject.CheckProperty(Aliases.browser.pageName.formAspnetform.submitbuttonDelete, "value", cmpEqual, "Delete") I've tried FindChild: myBtn = Aliases.browser.pageName.formAspnetform.FindChild("submitbuttonDelete", "Delete*") if (myBtn.Exists): Log.Message("The button exists, so press it and wait") else: Log.Message("The button doesn't exist, nothing to do") I must be missing something very simple, and am throwing in the towel after about 4 hours combing through the reference and googling. I'd rather not suppress logging around this. Any advice? Thanks!Solved626Views0likes2CommentsRe: Multiple developers editing a TestComplete project
We appreciate the quick responses, and will try out the suggestions. Still have quite a lot to learn about the product...it's been several years since I've used it last (prior product from early 2000s), and much has changed. Thanks again!658Views0likes0CommentsMultiple developers editing a TestComplete project
We have a single TestComplete license between 2 test developers, so we take turns editing the project, which is in its infancy. We're looking to purchase another license so we can both work on developing test solutions. We're thinking along the lines of a network share that the 2 of us plus the TestExecute machine can access. Is there a way for the 2 of us to work on a single project at the same time? If not, would we have to develop scripts locally and then somehow merge them together? My concern is that certain project-level assets may get dropped or corrupted. Thanks!718Views0likes4Comments