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