How to Loop through each file in a folder and for each file perform a set of activities?

[mojo001]

Hi guys, I’m wondering if it is possible to loop through a folder and for each file perform a set of activities? I have already set up Directory.GetFiles with the folder path and then added a for each activity to filter through each file, but each file is a template that then needs to be filled out. How do I dynamically open each file and fill out the information?

[AJ_Ask]

Hi @mojo001

Is it a Excel template?

then you can you “Excel Application Scope” to open each Excel file. Within the Excel Application Scope, you can use activities like “Read Range” to read the data from the file, perform necessary operations, and then “Write Range” to save the modified data back to the file.

[hrishikesh.k (Hrishikesh Kothale)]

Hello Mojo,

1. Use the “Directory.GetFiles” activity: As you’ve already done, use this activity to retrieve a list of files in the folder you want to process.
2. For Each File: Use a “For Each” activity to iterate through each file obtained from the folder.
3. Open Each File: Use activities such as “Start Process” or “Open Application” to open each file in the appropriate application. For example, if your files are Word documents, you can open them using Microsoft Word.
4. Fill Out Information: Depending on the type of file and the information you need to fill out, you may use different methods. For example:

• For text-based files (e.g., Word documents or text files), you can use activities like “Type Into” to input text.
• For PDF files, you might need to use OCR (Optical Character Recognition) activities to extract and input text.
• For Excel files, you can use activities to directly write into cells.

5. Save and Close File: After filling out the necessary information, save the file and close it using appropriate activities.
6. Repeat: The “For Each” loop will continue until all files in the folder have been processed.

Please let me know if your issue resolves.
Happy Automation.

[KevinE (Kevin)]

The question is far too vague, you have to know specifically what you want to do with the files.

[nisarga]

@mojo001
You can use “for each file in folder” activity to loop through each file .

[Gautham_Pattabiraman]

Need to fetch all the files from a folder and load those files in different table in database

Hello @Gautham_Pattabiraman , Colum_name(from 3 row) static but that some column name will be like above i mentioned 3 lines in a cell. But the first row will contain some other values in some other folder rest column name from 3 row will be same I tried writing the output in a excel it removed the row using delete row activity but when i tried assign activity to rename the column name there it throw error

@mojo001 ,

Check the above thread i have attached a solution