Get whole row value

[Aman_Mongar1 (Aman Mongar)]

Hi Experts,

I am trying to fetch the value of the row. When we do row(0).tostring, I am getting only A column value but what I want is whole row value. If there are A to C column fill. I want to fetch the value from A to C.
I don’t want to use row(1).tostring and get one value at a time. I want to get the whole value through one command.
Can anyone help

Thank you

[sureshj (suresh_hserus)]

@Aman_Mongar1

Could you explain after getting the value what is your use case?
Row holds the value of A to C column

Thanks,
Suresh J

[Manohar1 (Adicherla Manohar)]

@Aman_Mongar1

While Reading of Excel only try to specify the Range A1:C100 you will get only those values in Data table

Regards,
A Manohar

[Aman_Mongar1 (Aman Mongar)]

I want to move the row from one tab to another.

[sureshj (suresh_hserus)]

@Aman_Mongar1

I can’t understand what tab you mentioning.
If you want to add this row to other Datatable use add dataRow.

Thanks,
Suresh J

[Manohar1 (Adicherla Manohar)]

@Aman_Mongar1

Try to send screenshots of your input excel and the output file you are expecting.

[Aman_Mongar1 (Aman Mongar)]

I want to match Status and take row value

[MythicGold]

can you screenshot your workflow for this part and post here if possible?

[Luis261980 (Luis Nunes)]

For each ROW
Ok so you must first do something like this first:
(the errors are just becouse i dont create variables was just so you can see

Atention: Just exmple

Then write the output to where you whant