Need help in passing an excel cell value into a "type-into" field

Help Studio
,
1

Hello,

Good Evening

I want to create a bot which picks values from excel sheet & passes it onto a ‘Type-Into’ activity
Need help in passing a cell value into a “type-into” field. The bot keeps sending ‘data table’ value instead of cell value.

I am using activities, Read Range (to open excel sheet), While loop, Type - into activity, send hotkey(to press enter) , assign activity to increase count value.

image
image1554×833 51 KB

2

@Aneet
Welcome to the forum

it looks like you are trying to loop over the datatable rows and want to enter a current loop column value.

We would recommend to use for each row activitiy instead and row(ColNameOrIndex).toString

3

pass in

datatableOutput.Rows(rowNumber)(ColumnName).toString

or

use For Each Row activity, pass in CurrentRow(ColumnName).toString

4

do I need to declare ‘columnName’ before it’s use here?

I am getting the below error,
Main_with_excel.xaml: Compiler error(s) encountered processing expression “dataTableOutput.Rows(rowNumber)(columnName).ToString”.
‘columnName’ is not declared. It may be inaccessible due to its protection level.

5

dataTableOutput.Rows(rowNumber)("columnName").ToString

replace columnName with your own column

e.g. if you want to type the column called “Price”
then it will be
dataTableOutput.Rows(rowNumber)("Price").ToString

also note if you use for each row instead of while loop, you can avoid maintaining a rowNumber variable
CurrentRow("Price").toString

6

Hello @Aneet ,

As per my understanding you are looping through the set of data from the excel and you need to pass the value of a column to TypeInto activity. Is this correct?

Then you can do as below.
1)Use excel activity.
2)Read range activity and you will get the output to a DataTable
3)Use For Each Row in DataTable activity.
4) Use typeinto activity and inside the value type. (CurrentRow(0).ToString). This will print the values from the first column.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.