How to use the Excel Filter

Just Want the Black the Column
Can any one help me

Hi @krishnapriya_Anu,

Use filter data table


Use Assign with below expiration



Hi @krishnapriya_Anu

We usually don’t use the UiAutomation on Excel workbooks.
Suggestion to you would be use a read range activity, read the data into a dataTable.
Use filter dataTable activity, in which you can pass select option in select rows :
column name is empty

it would give you the required rows.

Happy Automation! :smiley:


either use filter DataTable activity, where you write DataTable.Select column name is " ".
or you can use Excel as DB and run a select query with blank column condition where you will get all rows with blank column.