UiPath How to loop through rows and columns in Excel sort search inputbox

[Pru]

How to loop through rows and columns in Excel sort search input box. This is similar like seach specified value in A column data.

Please help, I stuck a lot of time

[Tapan_Behera1 (Tapan Behera)]

Hi @Pru follow the below screenshot to get the column values from excel sheet.

[Gokul001 (Gokul Balaji)]

Hi @Pru

Welcome to Uipath community

As @Tapan_Behera1 Suggestion You can use For Each Row in DataTable activity to loop through all the row.

Regards
Gokul

[Pru]

Yes, after reading the excel A column data, I need to input the search box so that I can search the specified data row.

[Pru]

Finally, user who can get the specified result

[Tapan_Behera1 (Tapan Behera)]

Okay, you can use the type into activity and provide currentrow(“column name”).tostring

[anon88744563]

Hi @Pru

We can use 2 method

1. dt = dt.Select(“[StaffID]=‘S13’”).CopyToDataTable

2. Use “Filter Data Table” Activity
   

   

Thanks,
HariVishnu

[Pru]

I click the indicate on screen button and then to choose search box, but it disappearing.

[anon88744563]

Hi @Pru

What about below Xaml

test.xaml (8.3 KB)

Thanks,
HariVishnu

[Pru]

And I have another question. How can I make the data such as “S13” save to Sheet2?

[Tapan_Behera1 (Tapan Behera)]

You can use the activity like write range or append range or write cell activity for this.

[anon88744563]

Hi,
You Just Need to Change Write Range Activity and Mention Sheet Name

If you want that Sheet as Datatable
U have Build one Datatable and mention in FilterDatatable Activity

Thanks,
HariVishnu

[Pru]

BlankProcess.zip (13.0 KB)
Is it something wrong???
How can I get the “S13” row to generate in Sheet2?

[anon88744563]

Hi @Pru
Kindly Check below
you have mentioned “<” instead of “=”

Thanks,
HariVishnu

[Pru]

Filter Data Table error, noooo

[anon88744563]

Hi @Pru

Kindly Check Below Xaml

Test.zip (136.9 KB)

in WriteRange Activity
Note: Add Header in the property Panel

Thanks
Harivishnu

[Rahul_Unnikrishnan]

Hello @Pru

As per my understanding based on the screenshot that you have shared, you are trying to implement UI based automation on Excel. But UiPath is providing default packages to automate Excel without using the UI activities.

Excel Automation - Robotic Process Automation (RPA) | UiPath

[Pru]

Thank you for helping me !!!

[Rahul_Unnikrishnan]

Is your issue resolved?

Thanks