SenzoD
June 26, 2024, 7:11am
4
hi there,
I do not know your level of experience with UiPath but you can archive this by using the flow chat and create a counter variable that you will increment to align with a cell number.
you may find these helpful:
Studio - Flowcharts (uipath.com)
Hi,
I actually have a process whereby I need to read an excel file and input data into a website. My process are as follows:
Read Range and store in datatable
Create a WHILE loop
Type Into activities and Click activities inside While Loop
I wanted to know if instead of the While loop we could use a flowchart sequence. Maybe with a counter something like that? Where should we put the Type into activites and so on.
Can anyone help please?
Option Two:
Using the REFramework, you can: read the excel file in the initialization and Change the transatcionirtem type from Queue to DataRow and you can add all your actions in the Process state, see example below:
RE Framework with Data Table: Part 3 | Transaction Item as Data Row | UiPath Learner - YouTube
You need to make some small changes in the workflow like:
First change all the queue data type variables to the required data type.(Eg. Datarow)
Remove “Get transaction item” activity from the “Get Transaction Data.xaml”
Remove/Change the “Set transaction status” activity from Success,BE,SE sequences in the “Set transaction status.xaml”
I hope these changes are enough to remove orchestrator/queue dependency from REF.
UiPathinas, Please add if any further points/changes are required. …
Good evening Devjyoti,
Correct
This one depends on your goal. When I do projects that have an Excel file as the source of queue items, I always keep the Success/Exception workflows because I want those values written back to the Excel file to act a final status report.
When not using the Orchestrator, you will need to change the type of the variable TransactionItem and of all the arguments from QueueItem to System.Data.DataRow. This includes all the workflows it is being passed into.
This us…