June 2, 2022, 2:12pm
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…
use macros or vb script you can easily copy paste exact
or else use copy/paste range activity
June 2, 2022, 2:14pm
Will you please advise me how to do that…I dont know about VB script and macros
’ Macro2 Macro
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()
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.
June 2, 2022, 2:28pm
This is my excel file A there are lot more rows and columns…file B is empty fresh excel sheet
June 2, 2022, 2:29pm
No I didnt tried this…plz advise
@KKsekar is it allowed to use custom activities? If yes, can you try the below package and the Copy to file activity.
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
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…
Have you tried the
Copy/Paste Range Activity ?
@KKsekar , Have you Checked with
Copy Sheet Activity, Maybe it suits your case more.