Do you understand my way
My way is don’t care other
we can get only range
OK.Could you pls tell me how to color it?
Have you try set range color?
no, i don’t do it…
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.
Please try with copy paste range activity
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
Then give the range in the copy paste range activity…
You can give the ramge you wnat to copy as well…example below
if i want to filter ID=688.then how how to copy the color of whole row?
Thnaks in advance
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
Use filter activity again and select remove filters…it would remove that
no it didnot remove it.Could you pls do it?
data.xlsx (13.1 KB)
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
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?
Instead of filter…directly use find/replace activity which will give you the row number and that can be used to copy paste
Could you please show me how to copy/paste range? because I am getting the error while copy/paste the range?
Can you show what you tried