How to use the Excel Filter

[krishnapriya_Anu]

Just Want the Black the Column
Can any one help me

[RajKumar_DC (RajKumar Durai)]

Hi @krishnapriya_Anu,

Use filter data table

or

Use Assign with below expiration

Thanks,

[adiijaiin (Aditya Jain)]

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.

Thanks
Happy Automation!

[Abhi_H (Abhijit)]

Hi,

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.

Thanks