I have a folder on my desktop and I would like to get the filenames listed in an excel file.
Currently I have an assign activity where variable fileList = System.IO.Directory.GetFiles(“C:\Users\XXX\Desktop\YYY)”
I defined the FileList variable as an array of strings.
I am now struggling to get them listed in an excel file.
I tried using “for each” (for each item in fileList) but then I am kind of stuck… should I use the activities “write cell/write range”? If yes what range do I have to specify if I want it to loop and enter all filenames one by one, on a new excel row?
Thanks in advance,