Read multiple excel sheets and display data in message box based on a condition

Help
,
1

Hey guys,

I want to read these excel files Excel1.xlsx (7.9 KB) ,Excel2.xlsx (7.9 KB) ,Excel3.xlsx (7.9 KB) and display the names whose age is in between 30 to 50 range in the message box.

Thanks in advance :slight_smile:

2

@NiranjanKN

use Read Range activity to read data from excel file and will give output as dataTable and say ‘DT’.

And then try below expression:

       DT1.Select("Age > '30' AND Age < '50'").CopyToDataTable.DefaultView.ToTable(True,"Name")