Create Folders and word documents that corresponding to excel sheet names

boo2.xlsx (11.7 KB)
I have attached an excel sheet that has different sheet names. My automation needs to take the sheet names and make folders according to those sheet names and inside those folders i need to create a word document corresponding to those names. I have figured out how to create the folders and the word documents separately but cant make a workflow that will get the sheet names then create folders and then create word documents inside those folders. any ideas or a workflow would be great.


You can use “Excel application scope” activity to read the excel with “Get WorkBook Sheets” activity which will give list of sheet names. You can loop that list and create folder using “Create Directory” activity. Inside that loop you can create the word document as well using “Word Application Scope”.

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