How read multiple excel files using directory

Learning Hub
1

how to read multiple excel data using directory
for an example 3 different excel files are there I want to read the data from all 3 excel file how to read the data at a time
how can we do that

2

Hi @Chethan_P

Use Directory.getFiles to get all file name into a array variable and then use for each activity to iterate through array.

Regards,
Atul

2 Likes
3

OK i will read the data from all three excel but how to use the data in smtp
for an example i want to take email from the data-table how to use that data

4

Can you share the excel?

5

two excel file are there in folder i want read two excel file SalaryDetails.xlsx (8.7 KB) SalaryDetails121.xlsx (9.0 KB)

these are sample data but hear I want to read the email id and send email to that email id

6

User for each row activity to iterate through each row of excel.

To read email id use row.Item(ColumnName or column index).toString** inside foreach row

1 Like