in Education by
How to read an excel sheet and put the cell value within different text fields through UiPath? I have a excel sheet as follows: I have read the excel contents and to iterate over the contents later I have stored the contents in a Output Data Table as follows Read Range - Output: DataTable: CVdatatable Output Data Table DataTable: CVdatatable Text: opCVdatatable Screenshot: Finally, I want to read the text opCVdatatable in a iteration and write them into text fields. So in the desired Input fileds I mentioned opCVdatatable or opCVdatatable+ "[k(enter)]" as required. Screenshot: But UiPath seems to start from the begining of the Output Data Table whenever I called for opCVdatatable. Inshort, each desired Input fileds are iteratively getting filled up by all the data with the data stored in the Output Data Table. Can someone help me out please? Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
First of all, you can use read range activity to read data from Excel because it is quicker, works in the background, You can start your sequence something like this Note that add header is not checked This activity outputs a string containing all row items. What you want to do now is to access the items in the data table and output each one as a string in your ‘type into’ something like this you want to read the text ‘opCVdatatable’ in an iteration and write them into text fields right ?. This is a little bit more complex, but you can approach it like this. You can use a For Each Row activity and loop through each row in CVDatatable, setting the index property if required: The task is to get the selector correct here and make it dynamic so that it targets a different text field per iteration. The selector for the type into activity will depend on the system you are targeting.

Related questions

0 votes
    I have an excel sheet that has a data like this Position URL Company Location Developer /xyz/123/xyz ABC ... Would appreciate any help Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have an excel sheet that has a data like this Position URL Company Location Developer /xyz/123/xyz ABC ... Would appreciate any help Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I have tried several ways but somehow they dont look clean; I have a URL file in Excel format (400+ urls in a ... easy way to do it? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I am creating RPA. Text box have some default value. I want to enter my value after clearing that default value ... in for loop. Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I'm new to UiPath; however, by referring a online tutorial I was able to read the whole outlook email and ... or link would help. Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I am trying to extract data from below URL using UIPathhttps://www.marketwatch.com/tools/stockresearch/globalmarkets/ ... 5 Datatables? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I'm wondering where do I find the Read CSV file option in my UiPath Studio. Can someone please guide me where do I find that option ? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    While exploring the Automation tool UiPath Studio, I tried to add an element to the queue. But while executing, it ... . Thank you :) Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have to put an input on the site from Excel file which I have done successfully. The only thing i got stuck ... as per the Excel file Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have to put an input on the site from Excel file which I have done successfully. The only thing i got stuck ... as per the Excel file Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I am using a UIPath data scraping and working fine for multipaging. But, My requirment is get child page data using ... -a-site/7014/6 Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am using a UIPath data scraping and working fine for multipaging. But, My requirment is get child page data using ... -a-site/7014/6 Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I understand that it is possible to kick off a process in UiPath, using a powershell script. I do not have ... way of doing it? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    Learning RPA with UIPath. Happily extracting onscreen data from a website, processing it, using it, etc. However, ... this stage :/ Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    It's a UI path sequence. I am trying to read some URLs from an Excel file.Launch browser Go to URL from file ... save it as a file. Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
...