How to read all the excel file from a particular folder?

[nimin (nimzz)]

Hi Senthil,

First you fetch the file names of all the excel files in the folder.
Assign string, filelist=directory.GetFiles("location","*.xlsx")

After that, Inside a for each loop, iterate through each file name and use a "Read Range " activity to read each excel file to a datatable. Then use a “Write Range” activity to write the datatable to an excel file in the new location.