Saving a Path to a Variable

Help Studio
, ,
1

I am using “Use Excel File” to select the file from a folder. I would prefer to select the file using the option to browse instead of manually typing the path.

The image depicts a configuration interface for an Excel file process, displaying the file path with options for saving and creating the file within the scope. (Captioned by AI)
The image depicts a configuration interface for an Excel file process, displaying the file path with options for saving and creating the file within the scope. (Captioned by AI)522×442 16.1 KB

Once I have selected the file I would like to know how to add the file’s path to a variable for later use.

Forum Engagement Daily Reports
2

Hi @dhtguru

You can use assign activity , define a variable and save this path to that variable and then use it in your workflow.

Alternatively, you can choose to create asset in orchestrator and use get asset activity to fetch its value and then use in the workflow.

3

Thank you for the response. Is there anyway to use grab the path already captured. I would rather not have to type the path since it can be quite long sometimes. Is it possible to grab the value I highlighted in the picture systematically without having to type it myself?

4

@dhtguru

Try Reference as property of this activity

This image shows a segment of the UiPath documentation explaining steps for selecting and handling Excel files in automation. (Captioned by AI)
This image shows a segment of the UiPath documentation explaining steps for selecting and handling Excel files in automation. (Captioned by AI)1320×2037 192 KB

5

Hi,

The following may help you.

Excel.FilePath

image
image972×716 34.3 KB

Regards,

1 Like
6

@dhtguru,

Just click on that folder icon highlight in the below screenshot. This open the file selection pop-up.

A screenshot of the 'Excel Process Scope' in an automation workflow interface highlighting an Excel file path input field. (Captioned by AI)
A screenshot of the 'Excel Process Scope' in an automation workflow interface highlighting an Excel file path input field. (Captioned by AI)1073×909 75.4 KB

7

@dhtguru instead of hardcoding the file path use assign activity of string type variable and pass your file path in that variable and then use your variable in the excep process scope or better save your file path in Config file and then work on that .. thats the best approach

Cheers
Happy Automation

8

@dhtguru

You can click on the selected path and copy it to assign activity as well

Also generally if you need to copy any filepath..just right click with holding shift and you would see copy as path option which would give the fullpath as is

Cheers

9

Hi @dhtguru
Use assign activity before the Excel process scope and create a variable and pass the full path there & use like below,

The image showcases a sequence of actions in a RPA workflow involving assigning a file path to a variable, reading a workbook named 'ModifiedFile,' and using it in an Excel operation with specific settings. (Captioned by AI)
The image showcases a sequence of actions in a RPA workflow involving assigning a file path to a variable, reading a workbook named 'ModifiedFile,' and using it in an Excel operation with specific settings. (Captioned by AI)527×447 13.3 KB

If helpful, mark as solution.

Happy automation with UiPath

10

Hi @dhtguru

Refer the below image to save the file path in a specific variable. You can use that file path in various instances further in your process

This image depicts a workflow with steps to handle an Excel file in a programming or automation environment, including assigning a file path and displaying it in a message box. (Captioned by AI)
This image depicts a workflow with steps to handle an Excel file in a programming or automation environment, including assigning a file path and displaying it in a message box. (Captioned by AI)775×730 22.3 KB

Thanks!!

11

Perfect. Exactly what I needed!
Thank you.
Thank you all.

1 Like
12

You’re welcome. Mark my post as a solution

Thanks!!

13

I suggest doing the free training at academy.uipath.com as it will teach you how to do these very basic things.

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.