Insert Int32 value from Datatable into a form

Help
, , , ,
1

Hi there,

I would like to fill an online form with Int32 value from my earlier selected Datatable (Excel Table).
What should I use to select the specific value from the exact column?

Thank you in advance!

2

Hi @Varkino,

You can read cell value by providing cell address and store as int data type and write the same where is required.

Thank you

3

If you know the row item you can use

Type Into: Datatable.Rows(rowNumber).Item(“ColumnName”).ToString

4

Fine
welcome to uipath community
we got two options to do this
–like once after getting the datatable variable named dt from excel with read range activity
now use a TYPE INTO activity and mention like this
dt.Rows(rowindex)(“columnname”).ToString
or
dt.Rows(rowindex)(columnindex).ToString
where both rowindex and columnindex starts from 0 for first row and first column

like this is one way

and another way is using activity called GET ROW ITEM activity
where pass the datarow variable like this
dt.Rows(rowindex) and mention the column index or columnname and get the output with a variable of type string
https://docs.uipath.com/activities/docs/get-row-item

Cheers @Varkino

5

Thank you!

I tried the aboves but I am getting validation error, the online form allows only numbers to type into.

Any idea?

:S

6

yah thats fine
type into can type on to that
is there any other character along the numerical value
@Varkino

7

No :frowning:

8

hmm…ok
try with SET TO CLIPBOARD activity where pass the input string and use SEND HOT KEY activity with key as ctrl+v so that it will paste the value from clipboard to that field
@Varkino

9

Example:

I have in my excel table a column named: “Exchange rate”

My Int32 variable is ExchangeRate.

I have in the dt 400 rows and 20 columns and I would like to type into the online form this specific value.

I made my dt with read range.

How to choose the exact value?

10

so you want to enter each row into this form?

Use a for each row (datatable)
Type Into: row.item(“ExchangeRate”).ToString

11

Exactly :slight_smile: I try this out :slight_smile:

1 Like
12

so…then pass the input as row(“Exchange rate”).ToString to SET TO CLIPBOARD activity
and use SEND HOT KEY activity with key as ctrl+v

@Varkino

13

Can you sho me an example? :S

14

Hi

It worked thank you :slight_smile:

1 Like
15

Cheers @Varkino