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.