Forum Discussion

DarkShadows's avatar
DarkShadows
Contributor
7 years ago

Stores_ How to store excel spreadsheet and provide its path in scripts

Hello All, I'm trying DDT testing as Keyword tests in test complete, For this I'm able to  move all needed files into inbuilt store folder location of test complete however at one instance I need to...
  • tristaanogre's avatar
    tristaanogre
    7 years ago

    So long as the location of your excel sheet is within the path of the project, you should be fine.  The script solution I posted before does not apply.  

     

    As an example, I created a folder in a test project of my called "ExcelFiles".  The MDS file is in C:\Source\MyProject\ and the ExcelFiles folder is a subfolder of that.  When I create a data driven loop using that spreadsheet, I get something like this:

     

    This way, no matter where I copy my project to, as long as I preserve the folder structure, it will always be able to find the excel sheet I want to use.

DarkShadows's avatar
DarkShadows
Contributor

Thanks for script solution Robert,

just a couple of questions :
1)Does this script will run on any hosts machine or shall I need to update file path each time?

2)Can you suggest some solution on keyword recording scripts please (please find attached snapshot the current solution I'm using it but again this is by using my local desktop path.)

3) I'm looking for something that will help me to run this scripts on any machine without changing any filepath.

 

 

Thanks

Amit

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

So long as the location of your excel sheet is within the path of the project, you should be fine.  The script solution I posted before does not apply.  

 

As an example, I created a folder in a test project of my called "ExcelFiles".  The MDS file is in C:\Source\MyProject\ and the ExcelFiles folder is a subfolder of that.  When I create a data driven loop using that spreadsheet, I get something like this:

 

This way, no matter where I copy my project to, as long as I preserve the folder structure, it will always be able to find the excel sheet I want to use.

  • DarkShadows's avatar
    DarkShadows
    Contributor
    7 years ago

    Hi ,i implemented suggested solution and this easy folder structural way working fine so far, thank you very much for support and helping me , i'm really happy as i learn new thing today in test complete.

    :)

    Regards

    Amit!