Read an excel file and save it in datatable

[Sam_Abraham (Sam Thomas Abraham)]

You can have the excel file in a particular folder and using
Assign string, filelist=directory.GetFiles("location","*.xlsx") you can get the path of the excel,
Make sure that there is only the required excel files in your speciifed location

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

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. [read_excel]

To get the sheet name you can follow the below post

How to read sheet name of an excel file

Hello I want to read sheet name of an excel file . I am unable to understand example How to get the Sheet name from Excel hence want guidance in simple terms

Also to get the data extracted from excel you might need to store it somewhere like a queue