How to open a excel file with different Name

Help StudioX
,
1

Hi all, I would like to open an Excel from a folder whose name changes. The Excel is from a report and has a sequential number next to the name. The bot should always go into the folder and open the table without me telling it exactly what the table is currently called.
C:\Test\BOT\REPORT*“&”.xlsx"

2

give a try on
welcome to the forum
Directory.GetFiles("C:\Test\BOT",“REPORT*.xlsx”).First()

But we recommend following
use an assign Activity:
leftSide: arrFiles | DataType Array of String
right side:
Directory.GetFiles("C:\Test\BOT",“REPORT*.xlsx”)

Us an IF activity
Condition: Directory.GetFiles("C:\Test\BOT",“REPORT*.xlsx”).Length > 0
Then: FileName = Directory.GetFiles("C:\Test\BOT",“REPORT*.xlsx”).First()
Else: error handling of missing file

For StudioX maybe similar can be done with filtering by using the For Each File in Folder activity

3

In StudioX:

image
image687×620 21.1 KB

image
image694×669 20.5 KB

4

Thank you all, it works great.