How to open excel files inside a folder


#1

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?


#2

Hello.

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)


#4

Thank you. It solves my problem :slight_smile: