Delete filter rows values in excel

Help Studio
, ,
1

Hai , I excel sheet there is set of product details like ice cream,chocolate,juice , water . In that i filter water data and remove whole water value is excel . plz help me to solve this

2

Hey @Aarthy1,

You can use:-
1.Read Range to read all the data from the sheet.
2.Use Filter activity to filter the water data.
3.Write Range to write the filtered data in the excel

Thanks,
Sanjit

3

Hi,

use filter data table activity and remove the unwanted value

Regards,
Dhanush

4

But some time the product will changed, the identification is color like the removing data is in voilet color

5

Hi

can u provide the input and expected output

Regards,
Dhanush

6

Eg.xlsx (18.9 KB)

7

Hi,

Please check the below attached file
Sample .xaml (6.6 KB)

Regards,
Dhanush