Unable to Copy the color of filter cells

I’m trying to copy the color of excel rows after filtering the data but it did not color the rows.so how to do it?
my data is coming like this-


output should be like this-

how to resolve this issue?

TIA

Hi @Cuberoot ,
Activity can copy data only, not copy format file?
You can create file template with format to write data
or use VBA to create format to file
regards,

I cannot create a template because the file has a date column.

I see, but we can get only data to before date only
image

Thanks for your reply.


above green color highlighted is current date
Thanks

Hi
Do you understand my way
My way is don’t care other
we can get only range
image

OK.Could you pls tell me how to color it?

Have you try set range color?

no, i don’t do it…
Thanks
data.xlsx (13.0 KB)

Can you share your input file and expect output?
I will test for you

input file is in Sheet1 and output file is in Sheet2.
Thanks

2 Likes

@Cuberoot

Please try with copy paste range activity

Cheers

Hi @Cuberoot

Please find the below xaml for your reference

BlankProcess9.zip (50.8 KB)

Hope this helps!!

it paste whole data but I want some rows

@Cuberoot

Then give the range in the copy paste range activity…

You can give the ramge you wnat to copy as well…example below

Excel.Sheet("Sheetname").Range("C2:G2")

Cheers

if i want to filter ID=688.then how how to copy the color of whole row?
Thnaks in advance

@Cuberoot

After filter…use a find /replace activity and search for 688…which will give you the cell number like A6 or so which is stored in variable str…then use "A" + System.Text.RegularExpressions.Regex.Match(str,"\d+").Value + ":G" + System.Text.RegularExpressions.Regex.Match(str,"\d+").Value

Here change A and G as you need…row number will come from find /replace

Hope this helps

Cheers

after filtering activity it shows dropdown option in every column can we remove it-


TIA

@Cuberoot

Use filter activity again and select remove filters…it would remove that

Cheers

no it didnot remove it.Could you pls do it?
data.xlsx (13.1 KB)