How to get each file from folder and use in in use excel

[Mathkar_kunal]

hello,

I need to open and perform task on each excel file mentioned in specific path .
i am geting error while creating workflow. cehck below ss

what wrong i am doing.
help me on same.

[supriya117 (Supriya Allada)]

@Mathkar_kunal

Use currentfile.tostring

[vrdabberu (Varunraj Dabberu)]

Hi @Mathkar_kunal

Filter the files by “*.xlsx”

Then in excel file use CurrentFile.ToString

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Mathkar_kunal
Assign

arr_Files=Directory.GetFiles(“FolderPath”)

Take Normal For each instead of For each file in folder

[mkankatala (Mahesh Kankatala)]

Hi @Mathkar_kunal

First give excel process scope activity inside give use excel file activity.
when we use use excel file we have to encapsulate the use excel file in excel process scope activity.
Give CurrentFile.toString in the Excel file option in Use excel file activity.

Hope it helps!!