How do I copy a sheet in excel to another excel file with the format retained exactly from the source sheet to the destination sheet?

[Jaideep (Jaideep Das)]

I have tried to do so but the format always gets corrupted. I need to retain the formatting of the source sheet when I copy the same to the destination sheet.

[balupad14 (Balamurugan (BalaReva))]

Hi @Jaideep,

This activity will copy the work sheet without corruption of format.

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…

Regards
Balamurugan.S

[Nero9 (UiPath with Hashmi)]

Copying sheets from one Excel to another

I have used invoke code activity to copy data from one excel to another excel with retaining excel data format Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim nb As Microsoft.Office.Interop.Excel.Workbook Dim ws1 As Microsoft.Office.Interop.Excel.Worksheet Dim p_ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range ‘capturing the range of sheet’ Dim p_rng As Microsoft.Office.Interop.Exce…