Naming New Files According to Excel Rows

Help
1

Hello all,

I have not been able to find anything on the question I have. The action is straightforward: I have an excel file in which there are a few dozen columns and hundreds of rows. I want to create one folder per row of one specific column and name the folders after the content of the corresponding row. Any ideas?

Thanks in advance.

1 Like
2

Hi,

Read the excel then, loop foreach row, there you can use CreateDirectory activity to create directory. if still more specific requirement, please elaborate in little detailed way

1 Like
3

Thanks for your reply. For each row I want to create an individual directory, with the name being the content of the cell. Does your approach work for creating “dynamic” directories?

4

Hi,

Yes, that can be done.

Loop - For each row
- Create Directory - Pass the cell value to create the directory

Note: If you have same directory name, then check before creating it using Path exists Activity with Directory option in it.

2 Likes