Unable to Copy the color of filter cells

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)

@Cuberoot

I did try the same …did you sue filter activity and marked remove filters check box?

are you not able to see full data? after removing?

or do you want the filter menu itself to be not seen?

if second is the case…then dont filter at all…instead search for id find the column and copy paste it

cheers

After tick on removing filter in filter activity it shows all the data.instead search for id find the column and copy paste it-how to do it?

cheers

@Cuberoot

Instead of filter…directly use find/replace activity which will give you the row number and that can be used to copy paste

cheers

1 Like

Could you please show me how to copy/paste range? because I am getting the error while copy/paste the range?
Thanks

@Cuberoot

Can you show what you tried

cheers

1 Like