How to loop through files in a folder and put files in a new folder

Help Studio
, ,
1

please help

I have a folder, in the folder there is a CSV format file. I want to filter a CSV file to only take some data. then I want to convert the CSV file into an Excel file and put it in a new folder.

How do I do the above activity repeatedly with many and different CSV files?

2

Hi @Kia1

Try this

Path.GetFileNameWithoutExtension(CurrentFile.ToString)+".xlsx"

image
image900×1234 62.1 KB

Regards,

3

image
image1374×606 42.5 KB

An error occurs, how to resolve it?

4

@Kia1

Give CurrentFile.ToString and check the updated code above

5

Thankyou,

I have question

I already have a folder containing excel files that I haven’t converted. Now I want the data in the Excel file to be automatically copied to the Excel template file that I have. after the data is copied to the excel template file. The template file is sent directly to email from the data I have.

please help, how can the task flow be implemented using UiPath?

6

For Each File in Folder

  • Read CSV current file into datatable
  • Filter Data Table or other methods to get it down to the data you want
  • Write Range into Excel file in the other folder (you don’t write it then move it, just write it directly in the folder you want it in)