Forum Discussion

cjfoeller0404's avatar
cjfoeller0404
Occasional Contributor
2 hours ago

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
Icon for Champion Level 3 rankChampion Level 3
1 hour 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
    33 minutes 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?: