How to open excel files inside a folder


Hi guys, I want to open excel file inside folder during a loop. How can I do it?

For example, I want to get all excels path (e.g. C:\folder\excel.xlsx) inside the (C:\folder), and then do a loop to open the excel to perform actions for each excel.

Is there any packages to perform the actions above?



There is an example in library that gets all the files from a certain folder. You can find it under Snippets->Loops.
After you get the files you could check to see if the extension matches with a excel one and do the steps in there.

I have attached an example.

WorkWithMultipleExcelFiles.xaml (8.3 KB)


Thank you. It solves my problem :slight_smile: