How to take multiple Excel files with file name * ENV * which have extension * .xls, * .xlsx, * .xlsm(dynamic file search) How to iterate over Excel files dynamically?
Use the Get Files action in the File Management utility, you can supply a pattern string to match the files (in your case, it will be "*ENV*.xls,*ENV*.xlsx,*ENV*.xlsm"). It will return a collection with the files names, which you can then iterate over using a loop.
------------------------------ Nicholas Zejdlik RPA Developer ------------------------------
Use the Get Files action in the File Management utility, you can supply a pattern string to match the files (in your case, it will be "*ENV*.xls,*ENV*.xlsx,*ENV*.xlsm"). It will return a collection with the files names, which you can then iterate over using a loop.
------------------------------ Nicholas Zejdlik RPA Developer ------------------------------
