How to get the record from excel file using inputbox

excel

#1

Hi Guys,

I’m trying to do a search on an excel file using inputbox.I’m trying to scan the serial number field but I can’t find a way to do that on UiPath (like I’m searching a name on a database using SQL and it will return a single record from the file).

Any help please. Thanks in advance


#2

Hi @Iyce_Winsoft,

Use the input box to receive the data and store it in a variable.(Lets say “input_name”)

Please try to use Excel Application Scope Activity and specify the Excel file directory which needs to be searched.

Later use read range activity to read the entire Sheet and stroe it in Data table(lets say DT_IN)

Now use " For Each Row "Activity under Data Table and iterate through each of the row.

Now use Get row item activity and specify the Column name (name of the column)or Column Index ( for col 1 -> specify column index as 0 ).

Check if that column contains the name that u have stored in Input_Name variable.

I have attached a xaml file for your reference, try this.

Hope it help.

Regards,
Prashant SinghMain.xaml (14.2 KB)


#3

Thank you for your response. I’ll try it and let know if got a result.