I am trying to get the contents and count of files from a folder and then write the names on to an excel file where I will be further refining the name to arrive at the data I want. I have 2 issues here for which I would love some help;
- I am saving the names of the files in a string array, how do I now convert this to make the bot write it in an excel? I have tried Build data table->for each->(body ->add data row)->output data table->write range. I get an error regarding column length(the method I’m using here is something I saw from an example someone posted here)
- Also is there a way for me to save the option clicked by the user in a select folder activity and call it for the subsequent activities for the aforementioned requirement? Or is pasting the path the only way to get the count and then the names of the files from the chosen folder ?
I know I am doing something wrong here, any help will be great
Thanks and Regards,