Read Range with different Excel name

Hi, i want to read range with a different excel name. The excel comes from a Report and thats the rason for the diffenerent name. The Folder is the same but a part of the Excel name is different. on the Uipath Studio X works but on the Studio not. Who´s can i help me?

@NHoe

If you can provide few example of Excel name then we can try to help

Thanks

Hi, “C:\Test\REPORT742.xlsx” t Number is change at the next report, that is the problem.

Hey @NHoe

Instead, You can try reading the file inside the folder directly

Like,

for loop item - Directory.GetFiles(“C:\Test")
{
item.Tostring // This would be complete path for your excel file
Read Range: Item.ToString
}

Br,
Goutham