Extract each ID from excel and get related information

Help
1

Hi,

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.

image
image350×568 11.1 KB

2

Hi @Delhibabu,

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

screenshot look like your process is correct only

Regards,
Arivu

3

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

1 Like
4

Hi,

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!

5

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
6

Hi,

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)

image
image1456×74 3.75 KB
and Im unable to ‘save as’ the information for each ID. Is there any alternative to save each file as part of automation.

Cheers!

7

Hi,

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.

8

Hi,

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

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!

9

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

1 Like
10

Hi,

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?

Thanks!

11

Hi,

For that you can go with Send HotKey Activity.

12

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

13

Send%20Hotkey
Send%20Hotkey2020×443 84.6 KB