Copy and paste data from one excel to other excel with the same cell color and format

[KKsekar]

I have two excel files… File A and File B. From file A I need to read a sheet and paste data into File B with the same cell colors and format. I have used read and write range but the colors and format are not getting. If I use preserve format some data format are changed.

If I try manually copy and paste the data from file A to file B its as expected format…

Please help to solve this…

[Veera_Raj (Veeraraj Sethuraman)]

use macros or vb script you can easily copy paste exact

or else use copy/paste range activity

[KKsekar]

Will you please advise me how to do that…I dont know about VB script and macros

[Veera_Raj (Veeraraj Sethuraman)]

Sub Macro2()
’
’ Macro2 Macro
’

’
sheet1.activate
activesheet.cells.select
Selection.Copy
sheet2.activate
ActiveSheet.Paste
End Sub

[Erick_Chavarria1 (Erick Chavarria)]

Hello @KKsekar.
Did you try with:
DataTable.Clone Method(): ??
It clones all the datatable schemas and constraints (structure)

It’s something like that.
DataTable newTable = originalTable.Clone()

[Rahul_Unnikrishnan]

Hello @KKsekar

Can you please share 2 excel files and explain which values needs to copy to another file.
Based on that we can try out some methods.

[KKsekar]

This is my excel file A there are lot more rows and columns…file B is empty fresh excel sheet

[KKsekar]

No I didnt tried this…plz advise

[Rahul_Unnikrishnan]

@KKsekar is it allowed to use custom activities? If yes, can you try the below package and the Copy to file activity.

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

[supermanPunch (Arpan)]

Hi @KKsekar ,

Have you tried the Copy/Paste Range Activity ?

[KKsekar]

Tried i didnt worked

[supermanPunch (Arpan)]

@KKsekar

This is my excel file A there are lot more rows and columns…file B is empty fresh excel sheet

@KKsekar , Have you Checked with Copy Sheet Activity, Maybe it suits your case more.

[jessika.torres]

@BalaReva.Excel.Activities

ther file is not exists, you can set the property “Auto File Creation” = true. It creates the file automatically and copies the worksheet.

Activity

Hello! I use StudioX. Could you please provide how to copy a tab from one workbook to the other un StudioX?