A_Roskoshnyi
Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Not able to grab data from Excel using TestComplete with wrapped text using Excel.Open("filename")..
Try some modify your code: var excel = Sys.OleObject("Excel.Application"); excel["Workbooks"].Open(path_to_excel_file); excel["Sheets"](name_of_sheet).Select(); //Get value from cell with rowIndex = 6, columnIndex = 1 var text_from_cell = aqConvert.VarToStr(excel["Cells"](6,1));Freakly Exception
Testcomplete version: 15.51.18.7 x64 Applying: WPF-Application Look at this part of previously working code: //pobjEdit - alias for editable TextBox object, passed as a parameter //in legacy tests this is a string //in new tests - OnScreen object //for compatibility is using eval() pobjEdit = eval(pobjEdit); if(pobjEdit["Exists"] && aqObject["IsSupported"](pobjEdit,"Focus")) { aqObject["CallMethod"](pobjEdit,"Focus"); } Results now after test running: eval(pobjEdit) give a error, if object cannot be evaluated. Why? Please, make a null-object again. some magic at "CallMehod" - Execption "JScript runtime error. The object does not support this property or method." It sometimes works, such as running the test again or set a breakpoint, but not always!!!Re: Seriously in Need of Help with the Name Mapping Editor
Marsha_R, it is true that we do not live in ideal conditions, and this is why I often take a very tough but pragmatic position. I advise everyone to watch this short video, it seems to me that it reflects life of tester very well: The Expert Draw conclusions yourself.
