Forum Discussion

maxrussell's avatar
maxrussell
Contributor
4 years ago

Excel data sources - using a relative path name for files

We need to use ReadyAPI across different machines. Our code is checked out from Git and sometimes our local directories differ (for example I use E:\, a colleague uses C:\)   As we need to share ou...
  • PrathapR's avatar
    PrathapR
    4 years ago

    Hi maxrussell 

    Can you please use relative paths.

    Instead of using  "E:/GitRepo/Test/Sample.xlsx" use ${projectDir}/GitRepo/Test/Sample.xlsx. Always keep these excel file folders(Ex:GitRepo/Test..) along with project file(.xml)  wherever you store, either in version control or local.  And Change like below at project level properties.

     

     

    https://support.smartbear.com/readyapi/docs/testing/best-practices/root.html

     

    Thanks!

PrathapR's avatar
PrathapR
Frequent Contributor
4 years ago

Hi maxrussell 

Can you please use relative paths.

Instead of using  "E:/GitRepo/Test/Sample.xlsx" use ${projectDir}/GitRepo/Test/Sample.xlsx. Always keep these excel file folders(Ex:GitRepo/Test..) along with project file(.xml)  wherever you store, either in version control or local.  And Change like below at project level properties.

 

 

https://support.smartbear.com/readyapi/docs/testing/best-practices/root.html

 

Thanks!

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    4 years ago

    Thanks everyone!

     

    maxrussell Does the suggestion help? Please let us know.