Get whole row value

Help
1

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

2

@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

3

@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

4

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

1 Like
5

@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

1 Like
6

@Aman_Mongar1

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

7

image
image1884×116 8.48 KB

I want to match Status and take row value

8

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

9

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

test.png
test.png676×532 13.5 KB

Then write the output to where you whant