Inserting the file path of a folder into a new column of excel

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?


  1. First create one DataTable using Build DataTable activity and provide one column name.

  2. 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.

  3. Finally use Write Range activity to write into Excel file.

I have put the file path data in an existing excel file