Questions Regarding UIPath Scripting

[JoeCap]

1. How do I create activities to select items in a drop-down list? The field shows a default value and I want to select a different value. Currently it gives me an error on how it couldn’t find the element.

2. When I scrape text from a web page, the UIPath selector highlights more than I want to scrape (and subsequently copy to an Excel cell). How do I make it only scrape a portion of the blue highlighted area it gives me? It allows me to encircle in red the number, but scrapes the whole thing:

3. How do I create activities in a script where the script each month when it runs needs to adjust and accurately select dates in a pop-up calendar, and the dates would change each month? For example, the report prompts a between date (start/end date) with a pop-up calendar for each. each month it has to change forward by a month, identifying the start which would be the 1st of the month on the pop-up calendar, and the end date which would be the last calendar date of the month. Each subsequent month it needs to change to the next month. how do I script for this?

4. How do we create activities in a script that allow for on the first script run to copy text in a range of Excel cells, save the Excel file, and then on the subsequent script run copy text to a separate range in the same Excel file?
   a. That is, I want to keep each script run’s pasted data to Excel in the same file, and don’t want to overwrite any previous scraped data from previous script runs.
   i. How do I create activities that make it know to advance to a separate range of cells each time ongoing into the future?

[PrankurJoshi]

First of all these are lot of questions which should have gone to different topics to search. Anyways let me try -

Ans 1 - You can use a click activity to select Items from a dropdown or alternatively you can send hot keys to do the same here are some post what you should visit -

Activities - Select Item

How to dynamically select a value from dropdown using 'Select Item' activity?

Hi, Can any one help me in selecting an value from dropdown using ‘SelectItem’ activity dynamically, Like lets take an example if the dropdown have 10 values in it, i want to select some 3rd or 5th some thing like that, the values will change dynamically so i need to depend on position of that value(i.e count). How can i do that using Select Item Activity. Thanks In Advance.

Ways to select drop down list

Hi Team, Attached work contains various ways to select drop down list. In case any other methods to select drop you can add the same and link the workflow to the same thread.,DropDownSelectItem.xaml (17.7 KB) project.json (239 Bytes) FindChildrenActivityRD.xaml (9.4 KB) SelectDropDownTypeInto.xaml (10.0 KB)

Ans 2 - You can use Get Text, Get Full Text, Get OCR text etc how ever after scrapping the data you will have to perform string manipulations on the result to get desired output. After this you can use Write Cell activity to write in a particular cell. Have a look here

https://studio.uipath.com/docs/output-or-screen-scraping-methods

Studio - Examples of Using Output or Screen Scraping Methods

Ans 3 - See this

Select date from calendar

How to select the date in calenders via uipath. For example: my input date was 6 June 2017. How to select the date in calender kind of tool

How to pass variable into selector

Hi, I have requirement where i need to choose the date field from calendar.(Website). i have gone through the post in the forum already . please find the screenshot of the selector where u can see aaname=21 is date field which i choose. so now i want to pass the variable in that field according to my required date field. How to pass it(any syntax i’m missing here)[image] any help must be appreciated .

Ans 4 - For this you can use write cell activity and in Excel Application scope checked a property Auto Save or you can explicitly use Save Workbook activity to save what you just write. If you write in different cells it will not overwrite. See these

Activities - Write Cell

Activities - Save Workbook

In your questions I did not get this part

**How do I create activities that make it know to advance to a separate range of cells each time ongoing into the future?**

Hope rest above would help you

[JoeCap]

Thanks Prankurjoshi. Few more questions I have to help clarify further:

Ans1 - Tried Select Item, but it just isn’t able to locate the UI element of the field with the drop-down on the webpage. In the step just previously, I was able to do it successfully using an Anchorbase, but with this next field it won’t work.

Ans 2 - How do I “perform string manipulations”. e.g. it scrapes the following: “463 records found”; and I only want to keep the 463 for typing into a cell in Excel in the next step

Ans 4 - I get this, but what I mean is how do I advance it. e.g. 1st script run, it pastes into A1-D1 of the excel file; then 2nd script run I want it to paste to G1-K1 of the same excel file; then 3rd script run I want it to paste to N1-Q1 of the same excel file, and so on.