Store data from excel and search one by one in an internal app and make changes accordingly

Hi All,

Since I am new to UiPath and i would need help to do below task. I was trying but could not able to do.

I have an excel file where a column is there with list of names in it. I need to read that excel file and search the names one by one in an internal/external app and then make changes which is common for all the names of excel.
Here is the excel file : Names List.xlsx (8.4 KB)

It would be a great help if you can share the XAML file.

Thanks in advance

Fine
Hope this would help you resolve this
—use excel application scope and pass the file path as input
—inside the scope use read range and get the output variable as datatable named outdt
—the use a for each row activity and pass the above obtained datatable variable as input
—inside the loop use. Open application activity to open then internal/external application by indicating that application as element
—the to pass each value from a column in our datatable use a assign activity like this
Str_value = row(“yourcolumnname”).ToString
Where Str_value is a setting variable
—now we can use this variable any where inside the application we opened
—now to change the values we can again use assign activity as well

Kindly try this and let know for any queries or clarification
Cheers @Nandan_Kumar_Prasad

1 Like

I was trying to do the same but not able to, bit confused.
Can you please share the xaml file for reference.