How to read 1 row from one sheet and write it in another sheet?

0 votes

Hi all, I want to read one row at a time and write that entire value to another sheet:

image

Here, I want to copy only row 3 and paste that row 3 in another sheet then copy row 4 and paste it in another sheet and so, on
dt_table.Select(“row namw=‘3’”)(0)(1).ToString : I can fetch data using this but I am getting only one value can anyone help me

Oct 23 in RPA by anonymous
• 13,960 points
22 views

1 answer to this question.

0 votes

Hello, you can change the query like this:

dt_table.Select(“row name=‘3’”)

And add it a datatable so that you can use the write range activity. Then using write range you can write this datarow into the new sheet.

answered Oct 23 by Abha
• 27,180 points

Related Questions In RPA

0 votes
1 answer
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12 in RPA by anonymous
• 120 points
118 views
0 votes
0 answers
0 votes
1 answer

connect uipath studio to orchestrator

This is a duplicate question. You can ...READ MORE

answered Sep 18 in RPA by Abha
• 27,180 points
117 views
0 votes
1 answer
0 votes
1 answer

Is there any way to get the number of New Items in a Queue?

Hi @Pratibha, yes you can get the ...READ MORE

answered Oct 23 in RPA by Anvi
• 13,960 points
13 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19 in RPA by Abha
• 27,180 points
375 views
0 votes
1 answer

How to connect to a database from UiPath and read data from it?

Hi Pratibha, to connect to a database ...READ MORE

answered Oct 16 in RPA by Abha
• 27,180 points
56 views