Naming New Files According to Excel Rows

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


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

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?


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.