Read Table in Excel

Help Studio
, ,
1

image

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

2

Use a read range workbook activity

Then filter the datatable

Regards

3

@ainaasyhda
U can use read cell value activity
image

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

4

image

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

image

5

Screenshot (36)
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

6

Use read range workbook , doont use Add data row activity