How to read excel files using multiple files in folder

Hi ,

my usecase i need to read multiple file in folder ,i used directory .get files("folderpath) this syntax.after i used foreach i can get each files from folder,but how to read it,i used read range activity ,it is thrown error.

@nirmalad123,

What’s the error you are getting?

Hie @nirmalad123 here are the steps to read


here the output of the files inside the folder

and if you want to read excel file and if you have multiple excel file inside the folder use this

image

Hi @nirmalad123

Make sure the sheet name for all the files are same, If not based on that you can give the sheet name.

Regards,
Gowtham K

Hi @nirmalad123

You can use the For each file in folder activity then it will iterate through each file in the specified folder. Inside For each file in folder activity insert the Read range workbook activity and give the CurrentFile.toString in File name field.

Hope it helps!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.