Replace rows and leave color of the celsl remaining

[kuzinyd]

Can i transfer row from one sheet to another with color of cell and other properties?
I grab rows from this table,relying on the value in column A

And I want to paste row to this table with red color

So, particularly in this case it would paste the 1st row and the 2nd. because values match.

Appreciate that

[AshwinS2 (Ashwin S)]

Hi @kuzinyd

Use Read range of excel and sheet and paste into another excel by using write range activity

use set range color activity and mention the range as A1:+Datatable.rows.count.ToString

Thanks
Ashwin S

[kuzinyd]

Hi, @AshwinS2
As per my knowledge output of read range activity is DataTable means that properties like color are not being saved when using this activity. I don’t wan’t to loose data in the final excel sheet, just to be able to replace matching values with color remaining.

[Palaniyappan (Palaniyappan P)]

Fine No worries
Kindly have a view on this thread and let know for any queries or clarification

Copy Excel data with all colors and all format

Hi @Charu_Rathi, It worked then. Thanks for your help! However i have another prob. i am using “format painter” directly clicking on it at excel then after it sometimes pop up something in excel saying that “i am copying large size…” Just like that. What i want to do is that when this pop up appears, i just need to close it or click cancel button in it to proceed to another activity but when i do nothing happens. What can i do? any suggestion? Appreciate your help. Here is the pop up message a…

Cheers @kuzinyd