Forum Discussion

DarkShadows's avatar
DarkShadows
Contributor
8 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
    8 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.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

Best bet is to place your spreadsheet somewhere within the project path of your MDS file.

 

So, for example, if your MDS file is stored in C:\MySource\MyProject\Project.MDS, then  put your spreadsheet someplace like

 

C:\MySource\MyProject\ExcelSheets\

 

Then you can use Project.Path or Project.ConfigPath in your string like Project.Path + '\\ExcelSheets\\' to get the path of your excel file.  

  • DarkShadows's avatar
    DarkShadows
    Contributor
    8 years ago

    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
      8 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!