I am about to learn how to work with UiPath and I am wondering how to automate the following example:
In every Excel Application Scope a Workbook bath has to be filled in.
Every time to robot is running i´d like to have the results stored in a different Excel File.
Is there a way to somehow name the workbook path or something else so that it works with a new Excel File?
You can use variable in the filepath of Excel application scope.
If you need to change the path for each run, then you can keep the value in config or asset.
If it needs to be changed for each iteration during a run, then you can update the value of variable for each iteration.
Hope this helps!
u means u want to have data of excel file in other excel file
First use excel scope and use read range and store whole excel data in a dataTable variable
second use another excel Scope with path defined and then use write range activity.
you need to put an file path to your file like ‘c:\documents\test.xlsx’
But you can use Assign activity with Array of String to store all files in your folder with this command:
System.IO.Directory.GetFiles(“C:\documents”,“*.xlsx”) Assign activvity:
After that you can use For Each loop to pass through every document in folder.