Insert Int32 value from Datatable into a form

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!

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

If you know the row item you can use

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

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
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

Cheers @Varkino

Thank you!

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

Any idea?


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

No :frowning:

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


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?

so you want to enter each row into this form?

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

Exactly :slight_smile: I try this out :slight_smile:

1 Like

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


Can you sho me an example? :S


It worked thank you :slight_smile:

1 Like

Cheers @Varkino