How to copy paste the single excel file sheets into diff excels by preserving the format while pasting into the new excels

Help Automation Ops
,
1

How to copy paste the single excel file sheets into diff excels by preserving the format while pasting into the new excels.

2

Hey @anjani_priya
use excel application scope inside that use get workbook sheets so it will give all the sheets inside that excel file now use for each to iterate the sheet one by one inside the for each read range and enable the preserve format option and then use write range .
or you can use copy method
Excel Application Scope (Source Excel)
Get Workbook Sheets → Store sheet names in a variable (e.g., sheetNames).
For Each(iterate over sheetNames):
Copy Sheet→ SourceSheetName to TargetWorkbook
Excel Application Scope (Target Excel):
Paste Sheet→ The copied sheet goes into the target Excel file.
Save Workbook → Save the target Excel.
Close Workbook→ Close the target Excel file.

cheers

3

@anjani_priya,

Use Classic activity Copy Sheet for this.

The image shows a workflow in UiPath Studio for copying a sheet named 'Sheet1' from 'Datanput.xlsx' to 'Dataestination' with the new sheet named 'Copied Sheet'. (Captioned by AI)
The image shows a workflow in UiPath Studio for copying a sheet named 'Sheet1' from 'Datanput.xlsx' to 'Dataestination' with the new sheet named 'Copied Sheet'. (Captioned by AI)2009×1239 102 KB

Sample code developed on Studio v. 2025

ExcelSheetCopy.zip (122.4 KB)

4

Hi @anjani_priya

Can you try this

A workflow automation setup for copying data from an input Excel file to an output Excel file using UiPath. (Captioned by AI)
A workflow automation setup for copying data from an input Excel file to an output Excel file using UiPath. (Captioned by AI)638×1212 32.2 KB

Make sure to check Read formatting as Display value

An Excel process scope interface is displayed, highlighting the selection of "Display value" for reading formatting from an "Input.xlsx" file. (Captioned by AI)
An Excel process scope interface is displayed, highlighting the selection of "Display value" for reading formatting from an "Input.xlsx" file. (Captioned by AI)913×597 21.2 KB

Or

The image depicts a workflow in a software application for reading data from "Input.xlsx" and writing it to "Output.xlsx," with options to add headers and use the display format. (Captioned by AI)
The image depicts a workflow in a software application for reading data from "Input.xlsx" and writing it to "Output.xlsx," with options to add headers and use the display format. (Captioned by AI)1234×385 32.3 KB

Regards,

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.