Loop the flow without "for", "while" or "invoke"

[amizi]

I can only use these for the flow:Use Application/Browser, Click, Keyboard Shortcuts, Type Into, Get From Clipboard, If, Assign, Terminate Workflow.
How am Is supposed to read excel file, row by row, until A cell is empty?
Or should I just copy paste my sequence? (3 rows of excel…)

[mkankatala (Mahesh Kankatala)]

Hi @amizi

With out using the Looping activities you can’t iterate the each row in the excel.

If you be more specific what is your requirement then only we can give the proper solution for your query.

Hope you understand!!

[ashokkarale]

@amizi,

Use Find First/Last Data Row activity. This will give you last row. Iterate using while loop till last row number.

Thanks,
Ashok

[SenzoD (Senzo Dlomo)]

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)

Flowchart instead of WHILE Loop

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

How to use REFramework without orchestrator

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

Diff in REFramework with & Without Queue

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…

[pravallikapaluri]

Hi @amizi

• Use a combination of activities like Type Into to navigate through cells and Get From Clipboard to retrieve data.
• Use an If activity to check a condition, such as checking if the current cell is empty to terminate the loop.
• Based on the condition, either continue the workflow (by calling the sequence again) or terminate it.

Hope it helps!!