Forum Discussion

MatthewB's avatar
MatthewB
Occasional Contributor
2 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
Champion Level 3
2 years ago

Again, the read is read correctly

 

What version of TestComplete are you using?

 

Try to use ODBC to connect to Microsoft Office Excel data, using the connection string e.g. “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file” - as I don't know what Excel.Open() method uses.

 

  • MatthewB's avatar
    MatthewB
    Occasional Contributor
    2 years ago

    15.51.18.7 x64 is the version.  Can you try to use the newly updated file named :  rptFailedRxVerifications.xlsx ?

  • MatthewB's avatar
    MatthewB
    Occasional Contributor
    2 years ago

    I'm not trying to have Excel installed unfortunately.  This is due to license concerns.