Forum Discussion

nastester's avatar
nastester
Regular Contributor
2 years ago
Solved

Setting Excel filename as project variable

Is there a way to set an Excel filename as a variable or something so if it changes name/location I can just update it once in one place?   I have a bunch of 'Excel- Read Value" operations in my ke...
Data-Driven Testing
Keyword Tests
Test Creation
Variables
Web Testing
  • Marsha_R's avatar
    Marsha_R
    2 years ago

    Try it without the quotes around it in the variable value. You might not need those.

Marsha_R's avatar
Marsha_R
Champion Level 3

Sure! Make it as a string variable

 

myexcelvariable = "c:\myexceldirectory\myexcelworkbook.xls"

 

then choose that variable any place you need the file name

 

If you need to combine it with another string, you would use it in a code expression similar to this

 

 

 

 

 

 

nastester's avatar
nastester
Regular Contributor
2 years ago

Hi Marsha,

When trying that, I am getting an exception saying file is not found.

See screenshots.

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3
    2 years ago

    If you hard code that same path into the test, does it work? 

    • nastester's avatar
      nastester
      Regular Contributor
      2 years ago

      Yes it does. When I hardcode a path to a network drive or local drive path, it works.

      • Marsha_R's avatar
        Marsha_R
        Champion Level 3
        2 years ago

        Try it without the quotes around it in the variable value. You might not need those.