Excel -Read Range Activity - read the range from the only excel file in a said folder

Help Studio
1

I need to read the range from the only excel file in a said folder. How do i specify it using the Excel - Read Range activity?

2

Try to give complete filepath ex: - ‘C:\ExcelFolder\sampleExcel.xlsx’ in Excel Read range activity.

Get me back if any issues

1 Like
3

But the filename is always different. That’s why i can’t specify the filename in full.

Thanks for your help!

4

@aileen.goh, you can check the directory contents with this function:
System.IO.Directory.GetFiles(“filepath”,“*.xlsx”)
Assign this to a array of strings so if you have multiple files in that directory then you can open each with for each loop and put that in read range activity.

More about this function:

1 Like