Welcome to UiPath Commuity Forum…Thats a great question to start with…
Alright lets take like this, first open the browser - web application with open browser activity
Then open excel application to get the cell details you want from single column name mycolumn and this can be done by using excel application scope activity
Inside excel application scope, you can use read range activity,
the output of the read range activity would be datatable with variable name out_dt
Use a for each row loop to iterate through datatable with input out_dt
Here comes the answer for you… use type into activity to enter your details…with input like row(“mycolumn”).Tostring where mycolumn is the name of the column from where you want to enter the details from each cell…either you can even mention the column index and it usually starts from 0 for the first column
Ahhhhh you might need like this either like you would like to enter the details from each row of each column…may be from left to right rather than from top to bottom like above mentioned
for that simple buddy, you can use row_counter initialised with default value 0…and column_counter with 0
Just with assign activity inside any loop condition, put like
mycellvalue = out_dt_Rows(row_counter)(column_counter)
increment the row_counter keeping the column_counter as 0 untill all the cells in a row of all column is read…(from left to right fullyy)
then increment column_counter with +1
and then repeat same for all the rows…
UiPath.Core.Activities.OpenBrowser A container that enables you to open a browser at a specified URL and execute multiple activities within it. # Properties ## Input * Url - The URL that you want to open in the specified browser. *…
Read Range: Use to read the Excel file and store all the data on a DataTable variable.
UiPath.Excel.Activities.ExcelReadRange Reads the value of an Excel range and stores it in a DataTable variable. If the range isn’t specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from…
For Each Row: Use to iterate through all the rows from the DataTable
UiPath.Core.Activities.ForEachRow Executes an action once for each row in the DataTable provided. # Properties ## Input * DataTable - The DataTable variable for which an action is to be executed once for each row. ## Misc * Private…
UiPath.Core.Activities.TypeInto Sends keystrokes to a UI element. Special keys are supported and can be selected from the drop-down list. # Properties ## Input * Text - The text to be written in the specified UI element. Special keys are…