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

Now I'm getting this,

I'll try and figure out what the issue is.

 

ODBC doesn't require a license. It's a standard application programming interface (API) for accessing database management systems

MatthewB's avatar
MatthewB
Occasional Contributor
3 years ago

So the license won't be required for Excel?  I think we can try out the Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; method you mentioned above.  

  • MatthewB's avatar
    MatthewB
    Occasional Contributor
    3 years ago

    We can't have Excel installed on the machine in this test environment.