Forum Discussion

kevinkleint's avatar
kevinkleint
Contributor
8 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.   C...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

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
8 years ago

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

  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    8 years ago

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

    • kevinkleint's avatar
      kevinkleint
      Contributor
      8 years ago

      Reading from Excel fails ...

      • AlexKaras's avatar
        AlexKaras
        Community Hero
        8 years ago

        Hi,

         

        How exactly you are reading? Screenshot/code snippet/etc.