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?