Copy paste values and format uipath

Help Studio
, ,
1

Hi
I want to copy paste values and format, but there is all only. I don!t want formulas.

The image shows a user interface for copying and pasting a range between two Excel sheets with options to copy all, values, formulas, or formats. (Captioned by AI)
The image shows a user interface for copying and pasting a range between two Excel sheets with options to copy all, values, formulas, or formats. (Captioned by AI)623×409 13 KB

2

Hi @Murat
You could use Copy/Paste Range twice. Once to paste Values and then Format. It is Fast enough, not much difference in performance either.

Workflow:

The image depicts two settings for copying and pasting range operations in Excel, where the first copies values and the second copies formats from "Sheet1" to "Sheet2," both marked with green highlights. (Captioned by AI)
The image depicts two settings for copying and pasting range operations in Excel, where the first copies values and the second copies formats from "Sheet1" to "Sheet2," both marked with green highlights. (Captioned by AI)576×480 16.5 KB

Input in Sheet1 :

The image shows an Excel spreadsheet with order details including order numbers, dates, and statuses, with a formula calculating the count of "Complete" orders, resulting in a count of four. (Captioned by AI)
The image shows an Excel spreadsheet with order details including order numbers, dates, and statuses, with a formula calculating the count of "Complete" orders, resulting in a count of four. (Captioned by AI)584×349 14.3 KB

Output in Sheet2 :
As you can see, formula is not pasted.

This spreadsheet displays order details with highlighted rows indicating status changes, and the cell C10 contains the number 4. (Captioned by AI)
This spreadsheet displays order details with highlighted rows indicating status changes, and the cell C10 contains the number 4. (Captioned by AI)349×292 9.93 KB

If this solves your query, Do mark it as a solution
Happy Automation :star_struck:

1 Like