Hi Folks, I have an excel file with template as below. [image] I want to copy this file to another excel and preserve the whole format, also I want to clear out the data previously present, so that I can write new data there. What would be the best way to achieve this.

@shikharno.7 Excel Application Scope (Input: Source Excel File Path) 1.1 Read Range (Input: “Sheet1”, Output: sourceDataTable) Excel Application Scope (Input: Destination Excel File Path) 2.1 Clear Range (Input: “Sheet1”) or Clear the entire sheet 2.2 Write Range (Input: sourceDataTable, “S…

Hi @shikharno.7 => Insert the Use excel file activity and pass the excel file path. => Inside Use excel file activity insert the read range activity. Output - Datatable → In properties of read range activity make default for Read formatting option. => Use Write range workbook activity to write…

Hi @lrtetala , can I filter out Year ‘2021’ before copying using the Copy/Paste Range ?

@shikharno.7 Yes, based on your requirement you have to do it

@lrtetala , Could you please guide me to set the properties , if my requirement is to filter out ‘2021’ and paste that into a new excel file. [image]

By using Copy/Paste Range activity you won’t be able to filter

Hi @lrtetala , [image] I couldn’t preserve the formatting via Copy/Paste Range.

@shikharno.7 It Preserve the format it is working Once show your workflow Share the sample excel file if it is possible

Copy excel file to new location while preserving format

Help Activities

lrtetala (Lakshman Reddy) August 1, 2023, 10:30am 2

Hi @shikharno.7

1.Use Excel file of Original excel
2.Use Excel file of 2nd Excel
3.Use Copy/paste range activity to copy and paste the format and data
4.Use Clear sheet/range activity to clear the data

Copy/Paste Range isn't keeping the same row/column width and height

Topic		Replies	Views
Excel format issue - formulas impacted in Destination file Activities excel , activities , question	12	748	August 19, 2022
How to preserve Format while copying from an excel file Help	29	12738	May 31, 2019
Copy excel format Studio studio , question , activities_panel	4	218	April 23, 2024
How to copy paste the single excel file sheets into diff excels by preserving the format while pasting into the new excels Automation Ops question , automation_ops	4	55	April 15, 2025
Excel application scope write range Activities excel , uiautomation , activities , studio	17	2960	November 20, 2021

Copy excel file to new location while preserving format

Related topics