We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

Ilakkk's avatar
Ilakkk
Contributor
3 years ago
Solved

Read excel data/links in javascript test complete

Hi team, I have tried to read the data file using javascript in test complete.But shows error as "Type error: cannot read the property 'SheetByTitle' of null" function ExcelRead() {     var excelF...
data-driven testing
desktop testing
Script Extensions
script tests
Test Results
Variables
web testing
  • rraghvani's avatar
    rraghvani
    3 years ago

    There's no problem with the code, as it works (using TC v15.45.31.7)

    I suggest you check your spreadsheet

     

rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Use https://www.w3schools.com/js/js_loop_for.asp to iterate through the cells.