Forum Discussion

MatthewB's avatar
MatthewB
Occasional Contributor
3 years ago

Not able to grab data from Excel using TestComplete with wrapped text using Excel.Open("filename")..

We are using the Excel.Open("FileName").SheetByIndex(0).Cell("A",6).Value to grab data from excel.  The method works overall, but does not capture the wrapped text from Excel.  The result of the data...
desktop testing
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Using the same code as you have written, all the text is shown. I can see from the tooltip, that there is a carriage return in some of your cells.