Updating Multiple Excel Files at Once

excel

#1

I’m wondering if it and how it would be possible to loop through multiple excel files at once and update a specific cell in each of the files. I feel as though this is possible but I’m not sure of the best route to take. Looking for suggestions. Thanks!


#2

Hi @jpreziuso,

You can use Parallel activity in UiPath to perform task on multiple excel file.


#3

Thank you, I will try that.


#4

Unless something changed, I don’t think Parallel actually does everything at the same time, but you could try using an Invoke inside the parallel. From my understanding, UiPath still performs each action from left to right in order (not at the same time) but invoking workflows might work for that approach.

In my opinion, you would want to perform your update inside a loop for a collection of files, assuming you are updating each file with the same value in the cell.

In that case, you could do something like this:

For each file In System.IO.Directory.GetFiles(directory, "*.xlsx")
    Write Cell

//// sorry if I got the syntax wrong for the Get Files, but essentially you could run your Write Cell on multiple files without needing to create a new Write Cell activity for each file you want to update.

Regards.


#5

I will also attempt to set this up. Thanks for your help.