How to open all the excel files exists in a folder using 'Start Process' Activity and default "For Each File in Folder" snippet

Help
1

Hi

Scenario:
I have three excel files Excel1, Excel2 and Excel3 in a folder. And i am using default snippet “For each file in folder” provided by Uipath. Not sure what values should i pass as input for Arguments,FileName and Directory in the Start Process Activity to open all three excel files and not other files(example: .pdf,.txt etc).

Can someone help me with a way to handle this scenario.

Attaching .xaml file for reference.

Thanks in advance

-VenkatMain.xaml (6.6 KB)

2

Steps:

  1. Use assign activity, with a collection of .xlsx files. DirectoryInfo.GetFiles(folder, filtertype)

  2. Use For Each item in ListofFiles
    Item.FullName → will give you the full path of the file. Pass this to the process.

Regards,
Karthik

1 Like
3

Hii…

Please have a look at the workflow.

Main.xaml (6.5 KB)

Warm regards,
Nimin

3 Likes
4

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