Extract excel data and insert into "Type text into activity"

Help Activities
,
1

Hi, i am a newbie to UI path and trying to use RPA to create telegram contacts from excel database. I have a challenge after excel read range activity on how to paste the extracted excel info into “type text activity”. For kind advice please.:face_in_clouds:

1 Like
2

Hi @Teo_Rachel

Where you want to paste the extracted information? Also can you show picture of your flow. To get more idea

Type text is used to paste the text inside the element that you want, you need to focus wherever on the UI where you want to paste the text. You can use this activity when automating applications

Input type will be string. After the read range you will get datatable as output.

You can use type into activity for setting the text into any application. This will help. Click on the indicate the element on the screen then select where you want to paste the data
image
This will also help!
https://youtu.be/QYApjVUzclE?si=UPyFooLr7RzIeSHQ

3

@Teo_Rachel

Welcome to the community

You want whole of datatable to be pasted then use output datatable activity which will convert datatable to string and we can pass string to type into

If you want each row seprately and each firld separately then use for each row in datatable activity

And inside loop use currentrow(“ColumnName”).ToString where column nameis the column you need from the specific row…as it itwrates through all rows…you will get value from that column in every row for each iteration

Cheers

4

Hi @Teo_Rachel

  1. After Using Read Range activity - create an output DataTable variable (dt_input) to store all the
    info of your Excel
  2. Now use the For each row in DataTable activity to loop through each row
    for each - currentrow
    in - dt_input
  3. Next, Use the type into activity and pass - currentrow(by your excel column name or by index
    number)
    Ex : currentrow(0) or currentrow(1) or currentrow(“Col1”)
5

Hi

  1. Read Excel Range: Use the “Read Range” activity to extract data from your Excel file. This will output a DataTable variable.
  2. For Each Row: Use a “For Each Row” activity to iterate through each row in the DataTable.
  3. Type Into Activity: Inside the “For Each Row” activity, use a “Type Into” activity to simulate typing the information into the desired field in Telegram or any other application.
  • For the “Type Into” activity, you can use a dynamic selector to specify the input field where you want to type the information. You might need to inspect the Telegram input field using UiExplorer to get the proper selector.
  • In the “Type Into” activity, you can use dynamic text by concatenating the values from the current row in the DataTable.

EX : CurrentRow(“ColumnName”)

Thank you