Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-11-20 09:53 AM
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?
------------------------------
Максим Уманец
------------------------------
How to iterate over Excel files dynamically?
------------------------------
Максим Уманец
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-11-20 04:08 PM
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
------------------------------
------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-11-20 04:08 PM
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
------------------------------
------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------
