Copy columns from One excel sheet to another + Preserve Style + Color of columns

test.xlsx (8.5 KB)
I have the columns like the image above.

I have to copy paste it in a diff excel file (test-Copy). The style and the color has to be preserved.

I have attached both the excel files.

test - Copy.xlsx (8.1 KB)

Can anyone help me out with this?
@supermanPunch @ppr

had you already checked out the new modern activities e.g.:

I tried that. The data is copied but the style and colors are fonts are not preserved.

It just pastes the data into the new excel. I need the style and colors to be retained.

This is how it looks:


I want the copied data to look like this:


ensured that it was done with the modern activities and this was checked?

Looks like copy paste range activity is only when we copy paste in different sheets in same excel.

I have 2 different excel files.

Hello @Sairam_RPA

I think you can copy paste to other workbooks also. As per the document that is possible.
Please refer the below document for better understanding.