Read Table in Excel

[ainaasyhda (Ainaa Syuhada)]

Hi! How to read this kind of table?
I want to output the “Name” if On “26” the user is available

[B_H_Akshatha_Pai]

Use a read range workbook activity

Then filter the datatable

Regards

[Vikas_M]

@ainaasyhda
U can use read cell value activity

And then put an if condition as if: Not(cellvallueOutput Variable.IsEmpty)
then read cell value of Name field

[ainaasyhda (Ainaa Syuhada)]

I tried to read the table, however it return this error

[B_H_Akshatha_Pai]

this is the read range activity , i guess you used add data rows

In this activity give the path of your excel file (workbook path)
and give the sheet name
Leave the range empty

[Vikas_M]

Use read range workbook , doont use Add data row activity