How to copy one excel row to paste in another excel update row

[Raja.G (Mr.RPABot)]

Hi Guys,

This code is worked but first excel row copy to another excel updated row ,its paste last row but second excel last row is consider to header ,but i want first row is header that’s my problem

please can anyone help this

[balupad14 (Balamurugan)]

Hi @Raja.G,

You can use the Copy ToClipboard and Paste Clipboard activity that i have attached it here.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Regards
Balamurugan.S

[Raja.G (Mr.RPABot)]

Copy and paste working but its pasted wrongly, i want to paste following row but its paste last row is a header ,i want first is a header , i used 2 read range activity one read range is checked Add header another read range i couldn’t able checked because getting error.
but i want header in second excel also

[balupad14 (Balamurugan)]

Hi @Raja.G,

Can you send me the excel file. I will send the xmal with result.

Regards
Balamurugan.S

[Raja.G (Mr.RPABot)]

sure I I’ll send

[Raja.G (Mr.RPABot)]

@balupad14

I have attached excel and my code also, please kindly check it

Payroll_New.zip (32.7 KB)

[Raja.G (Mr.RPABot)]

I am used “Get row” and “Add row data table” only , not copy-paste activity ,because i need more rows in excel-1

[balupad14 (Balamurugan)]

Hi @Raja.G,

I have changed the Main.Xaml . Please take a look .

Sample : RajaG.zip (44.8 KB)

Regards
Balamurugan.S

[Raja.G (Mr.RPABot)]

@balupad14,

same activity i couldn’t able to see can u help this

[Manish540 (Manish Shettigar)]

Just create the new process in the uipath studio and copy-paste the above workflow inside the new process folder, then open it.

[Raja.G (Mr.RPABot)]

Thanks @Manish540

[Raja.G (Mr.RPABot)]

@balupad14,

Actually i am looking not static , i need dynamic , "“K2:K5” is a static .

suppose that row have 10 row filled than automatically reflected to in second excel.

[balupad14 (Balamurugan)]

Hi @Raja.G,

Keep the studio with the error . Go to the Manage and package. Follow the below steps.

Check these are checked.

Install the package.

.

Save and close the studio. Reopen it.

[balupad14 (Balamurugan)]

@Raja.G

Actually i am looking not static , i need dynamic , "“K2:K5” is a static .

The package has an activity called “Find LastRow”. you can use it like below.

I have changed the sample . you can check it .

RajaG.zip (44.9 KB)

Regards
Balamurugan.S

[Raja.G (Mr.RPABot)]

@balupad14,

Thanks i will check