How to get the whole row if cell value matches with the existing given value in uipath

Write your feedback, idea or concern here!

Read the whole Excel spreadsheet into a datatable and use a FilterDatatable activity to filter the column with the value you’re looking for.

1 Like

You can read the data table and write select query with where condition and the output will be list of rows, you can iterate them through and write them or you can use copy to data able and write whole data able at once.

1 Like

Thanks for your suggestion. I ll give it a try and let you know the status of it