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
Icon for Champion Level 3 rankChampion Level 3
2 years ago
Copy Link

I fully understand you can't have Excel installed, and I'm not suggesting to install Excel.

 

Since you have installed Microsoft 365 Access Runtime, try to use the example I've provided or try to use ODBC.

 

 

  • avidCoder's avatar
    avidCoder
    Super Contributor
    6 years ago
    Copy Link

    Hi Community,

     

    Currently, I am working for a retail and ecommerce based client. Their requirement is to replace all the massive mainframe with cloud microservices and to keep the individual services small, with responsibilities distributed accross a number of services. Coming to microservices testing part, I have to build a kind of framework using Rest-Assured/ReadyAPI to automate all the microservices.

     

    Choice is mine....!!!

     

    Thanks,

    avidCoder.