Read “dynamic range” from excel file with a “dynamic name” for the first sheet

Help Studio
, ,
3

Hi @jwetherin

you can try this, if its one file contain in the folder you can use the below expression if not use loop

Directory.GetFiles("C:Reports\output\","workbook*.xls")(0)

Regards,
Gowtham K