Forum Discussion

csachanandani's avatar
csachanandani
Occasional Contributor
3 years ago

TestComplete started failing tests that read data from Excel with Macros

I had TestComplete tests that would read data from excel with macros and now have started receiving "Excel internal error 'Element not found'." when I started running them now. Has anyone ever experi...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Using a single-backslash is used for escaping certain characters. A double-backslash returns a single slash. Also, the example shows

Are you calling the Open method more than once?

 

I'm curious to know, what is the full path if you were to run,

fileLocation = Project.Path + "Test Data\DataSheet.xlsx"
Log.Message(fileLocation)
//excelFile = Excel.Open(fileLocation+"Test Data\DataSheet.xlsx")
//excelSheet = excelFile.SheetByTitle["Test Data"]

 

  • csachanandani's avatar
    csachanandani
    Occasional Contributor
    3 years ago

    excelFile = Excel.Open("C:\\Automation\\Test Data\\DataSheet.xlsm") didnt work either. Also, Open method is called only once and then we read data from different sheets.