Excel automate in uipath

i have a data in excel
Column A
rpa
rpa
xyz
xyz
In column i want delete only rpa from the data and rest should be there which condition i can apply

1 Like

HI @Ak_4

Please Refer Below Solution.

DeleteParticularValuefromColumn.xaml (9.6 KB)

Thanku

Thank you for solution , can you share me the screenshot of it.

Hi @Ak_4

You can Try with Filter DataTable activity

image

Regards
Gokul

Hello @Ak_4

You can use Filter datatable by enabling remove in the activity. Then give the condition as Column A= “rpa”

  • Read the excel
  • Use filter datatable activity
  • Write range to excel

Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.