Forum Discussion

cjfoeller0404's avatar
cjfoeller0404
Occasional Contributor
5 days ago
Solved

How to Configure Relative Filepath for Stores|Tables Excel Sheet Import?

What is the process in which to use a relative file path to be able to import an Excel Sheet into a Stores|Tables object so that the table can be updated regardless of where in the file directory the...
  • rraghvani's avatar
    rraghvani
    5 days ago

    Assuming your .xlsx file is in Project\Stores\Files

    Then you can use Project.Path together with the remaining path

    // Using the standard open file dialog, to select a file
Sys.Browser(settings.GetBrowser()).WaitWindow("#32770", "Open", 1, 5000);
Sys.Browser(settings.GetBrowser()).Window("#32770", "Open", 1).OpenFile(Project.Path + "Stores\\Files\\WebcoverAddNewFile.xlsx");

     

rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
5 days ago

Assuming your .xlsx file is in Project\Stores\Files

Then you can use Project.Path together with the remaining path

// Using the standard open file dialog, to select a file
Sys.Browser(settings.GetBrowser()).WaitWindow("#32770", "Open", 1, 5000);
Sys.Browser(settings.GetBrowser()).Window("#32770", "Open", 1).OpenFile(Project.Path + "Stores\\Files\\WebcoverAddNewFile.xlsx");

 

  • cjfoeller0404's avatar
    cjfoeller0404
    Occasional Contributor
    5 days ago

    Alright, I have made a copy of my file and put it in a Files Folder in the Stores directory.

    Is there a way to do that through this UI Interface?:

     

    • rraghvani's avatar
      rraghvani
      Icon for Champion Level 3 rankChampion Level 3
      2 days ago

      No, you can't use Project.Path in that dialog, as it's only specific to JavaScript. You have to enter the full path instead.

      I use Stores Files to upload files.