Create and naming folders based on excel rows

Help
1

Hi All,

I have two columns in my excel: “ID” & “Name”, I have few rows for these columns.
I wan to make separate folders based on these rows in excel.
Example: Folder name would be like : ID1_NAME1,ID2_NAME2,ID3_NAME3… so on.
Please can someone help me with the steps?

As of now I have created this (refer below image):

image
image647×652 16 KB

1 Like
2

Hi,

you can use activity “Create Directory” for this purpose

3

I can see “create folder” instead of “create directory”
image

The code I wrote is: “Yourfolderpath\”+dt.Columns(“yourcolumnname”).Columnname.Tostring

its running successfully but it doesn’t create folders.

4

image

You can use create folder activity.

2 Likes
5

Thanks Shashi, I get it.

But I am not able to make folders when I run the program

6

Can you please try this “Yourfolderpath\”+row(“ID”).ToString+row(“Name”).ToString inside for each row activity.

2 Likes
7

Fantastic!!! it worked.

Thank you so much :slight_smile:

8

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