How could I get the value of each row in this workflow?

[pprin001 (Paolo70)]

Hello guys.

I’d like to get each value of reading the excel file:

desired action:
Getting values like:

Banco A
Banco B
Banco C
Banco D
Banco E
Banco F
Banco G
Banco H

I wouldn’t like to read the cell “Names” of the column, could you help me, please?. I need those 8 values to do the switch process.

If there would be another way to do it, please let me know.

Main.xaml (9.1 KB)
Nómina.xlsx (8.0 KB)

[Gokul001 (Gokul Balaji)]

HI @pprin001

1. Use Read Range activity → Store it as DtRead

2. Use For each Row in Data Table activity

Inside the For each Use Log message / Write Line activity

CurrentRow("Nombres").Tostring.Trim

Regards
Gokul

[RajKumar_DC (RajKumar Durai)]

Hi @pprin001,

What about this, i have done some changes in your workflow kindly check updated Xaml

Updated Xaml
Main New.xaml (11.8 KB)

CurrentRow.Current(0)

Changed workflow

Best,
Rajkumar