I need to get the all file paths of a folder into a new column of excel. I got the file paths stored in an array but failed to insert them in excel column. How can I solve this?
-
First create one DataTable using Build DataTable activity and provide one column name.
-
And then use ForEach loop activity to iterate one by one item from array of string and inside that use Add DataRow activity to add items to the DataTable.
-
Finally use Write Range activity to write into Excel file.
I have put the file path data in an existing excel file