Help! I’m new on this and I’m trying to make a file with all the excel names that are in a folder. I just can see the name of the excel files in a Write line but I can´t printed in an excel!! can you help me?
@denisselizeth I guess you are using System.IO.Directory.GetFiles(“YOURFILEPATH”) to retrieve files from folder.
THe result of this will be an array of strings. To write into excel, either you convert this result to a data table and use write range activity. else loop through array and use write cell activity to write the values.
My suggestion is to use write range because in write cell activity you need to hit the excel file multiple times.
Please let me if it helped. If not, please mention which part you need explanation for.
You could also join the array of files together then use Write Text file using .CSV as the extension.
To join the array you can use String.Join( )
So it might look like this:
String.Join(System.Environment.Newline, System.IO.Directory.GetFiles(“YOURFILEPATH”) )
Then put that in the Write Text file activity.
its working!!! thank you so much!!