Extract each ID from excel and get related information


Im a beginner and started using the Uipath recently. I tried implementing a bot which loads the ID’s from excel and add a for each loop which reads each row (but it reads only the last row! :frowning: ).
Now Im stuck to proceed further as I need to take each ID and fetch the corresponding documents from the webpage. Attached screenshot for reference.

Hi @Delhibabu,

Share your xaml file i’ll check and update you.

screenshot look like your process is correct only


Hey go through this example
excel_example.xaml (6.7 KB)
new.xlsx (8.4 KB)
you will find your desired result.

1 Like


Your example helped to write each row. Thanks for it. How can I call the each row & paste the value in an web browser to get the detailed documentation of each ID’s.

Would be great to understand it. Thanks!

hey, Use the appropriate activity for your desired solution in place of WriteLine activity in my example. Have a look at attached document .excel_example.xaml (9.4 KB)

1 Like


Thanks for the file. It worked perfectly and I completed 99% of the task. I have a small trouble in saving the detailed information as in IE it creates a small window (attached)

and Im unable to ‘save as’ the information for each ID. Is there any alternative to save each file as part of automation.



Use Recording and first click on the small arrow which is after save. when you will perform click “save as” button will pop up click on the save as button it will ask you the location where you want to save your file.


Yes, I have tried the same. Some how in recording it was unable to find the save button and throws below error.
-------- Error

Source: Click ‘drop down button’

Message: Cannot find the UI element corresponding to this selector:

Exception Type: UiPath.Core.SelectorNotFoundException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
UiPath.Core.SelectorNotFoundException: Cannot find the UI element corresponding to this selector: ----> System.Runtime.InteropServices.COMException: Cannot find the UI element corresponding to this selector:
at UiPath.UiNodeClass.FindFirst(UiFindScope scope, String nodeID)
at UiPath.Core.UiElement.FindFirst(FindScope scope, Selector selector)
— End of inner ExceptionDetail stack trace —
at UiPath.Core.Activities.ScopeActivity.OnFaulted(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Thanks in advance!

Save-as.xaml (7.6 KB)
Try this.

1 Like


Success it worked! Thanks for your support! Appreciated!

It works perfect and I have a very generic question when I run the bot its not super fast like how I see the Video examples. It works on it own but takes the time which is equal to a manual time. Is it possible to overcome & make it superfast?



For that you can go with Send HotKey Activity.

Will creating a hotkey using ALT or CTRL will make the bots to run fast?