Hello
I’m trying to get UiPath to get values from Excel and type them into a paper trading website, but I am unsure how this can be done. I would appreciate some help on this topic! I’ve posted my current workflow.
I recommend you to use “Read Range” and “For each row”
Read Range:
to extract information from excel to data table variable.
For each row:
iterating on each row of a data table
Inside Use Excel File
add below activities
Read Range Excel - Gives Data Table as output.
For Each Row In Data Table - Use Data Table as input
Use CurrentRow to access data from each row like CurrentRow(“Column_name”).ToString
Its better to read the excel to a data table first and then access the values from the datatable
Would the browser stuff be before the Excel Process Scope or would it be where you have the comment?
Use below outline
Use Excel File
Read Range
Use Application/Browser
For Each Row
Your Browser automation code
How do you get the data from the data table, I’ve made the outline, but I only have the choice of choosing from the excel file in the “Type Into”
Just set Max Iterations property of For Each Row to 5.
You should do the free training at academy.uipath.com as it teaches you how to do basic things like this.
1 Like