Copy Excel sheet data with Formula

Soni_Reddy2 · July 17, 2021, 2:31pm

Hello,

How to copy entire excel data with formula and i want to paste in different excel sheet

Can someone help with this?

ermanoj3101 · July 17, 2021, 2:51pm

You can use copy/paste range

Soni_Reddy2 · July 17, 2021, 2:54pm

Thanks for your reponse.

Using copy paste range activity i am able to paste in same excel sheet need to paste values in different excel sheet.

ermanoj3101 · July 17, 2021, 3:09pm

Got it.

Try below code and let me know if you face any issue.
CopyPasteDataToAnotherSheet.xaml (5.5 KB)

Note: Install package before using this code.

ermanoj3101 · July 17, 2021, 3:17pm

Is it worked ?

Topic		Replies	Views
How to copy excel sheet with a formula and paste it as value Activities excel , uiautomation , activities	2	790	August 1, 2022
Dynmic copy paste Activities excel	3	499	September 8, 2022
How to copy and paste sheet from one excel file to another excel file? Activities excel , activities , question	3	1119	August 24, 2021
Copy Excel Activities Studio studio , question , activities_panel	7	424	May 3, 2023
Copy formula from one excel to another Studio excel , activities , question	1	1085	March 24, 2020