How to read and write the data from entire row no matter what column I have in the spread sheet

Hello RPA developers. I just want to know how to read and write the data from entire row no matter what column I have in the spread sheet.

For example i have data in the spreadsheet like:

slNo Name Age
1 John 21
2 Adam 24

So if I just want to copy on first row data like 1, John, 21 to another spreadsheet. How do I do that?
I have used:
slNo=row.item(0)…toString
Name=row.item(1)…toString
Age=row.item(2)…toString

But what it does is that it loops through only particular column. What I want is I just want to loop through particular row inorder to get all the data from particular row.

Your help will be highly appreciated.

It will loop through the row not the column, so you can get the entire row data including name and age,

It is quite confusing, you want to loop through the column or row?

if i undertand you, what you whant will be like:

per Line:
slNo=row.item(0)…toString → A1
Name=row.item(1)…toString → B1
Age=row.item(2)…toString → C1

use another last assign to:

YouString= slNo+“,”+Name+“,”+Age = 1, John, 21

And all you line data rill be in the same row to past in another cell from another sheet.

im true ?