Getting Started

last person joined: 4 hours ago 

Get talking! If you're new to Blue Prism, use this community to help you get started.
Expand all | Collapse all

Excel

Jump to Best Answer
  • 1.  Excel

    Posted 11-03-2020 04:53
    Edited by Максим Уманец 11-03-2020 08:46
    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?

    ------------------------------
    Максим Уманец
    ------------------------------


  • 2.  RE: Excel
    Best Answer

    Posted 11-03-2020 11:08
    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
    ------------------------------



Share