Forum Discussion

kevinkleint's avatar
kevinkleint
Contributor
7 years ago

Office 2016 upgrade - TC no longer connects to Excel datafeed

Hi!

 

We recently upgraded to Office 2016. When I went to run TestComplete, the test failed and it said that it was unable to connect to the data source, which would be the Excel spreadsheet.

 

Could anyone please point me in the right direction?

 

Thanks,

 

Kevin Kleint

12 Replies

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

    When you upgraded to 2016, you changed the drivers being used for reading the Excel files.  So, what you had been referencing before as a data provider/driver no longer works.

     

    Question: Are you using KeywordTests or Script code for accessing the excel data source?

    • kevinkleint's avatar
      kevinkleint
      Contributor

      I access the spreadsheet through Keyword testing. But I use scripting to write to Excel.

      • Marsha_R's avatar
        Marsha_R
        Champion Level 3

        Which part is failing - reading from Excel, writing to Excel, or both?