Can we read excel in flowChart and loop through each rows from excel and repeate the some sequence?

Help Studio
1

Hi,

Is it possible to read excel in the FlowChart ? My scenario is i have to read data from excel and for each row from excel i have repeat sequence execution in FlowChart.

Please let me know can i achieve this? if yes how can i do it?

Thank you so much for the support we are getting till now.

Thanks,
Nivedita

2

Hi @Patil_Nivedita - Yes, you can while loop activity OR send the connector back to the sequence. Please check below screenshot

  • Take sequence within a flowchart, use Excel activities to perform the operations

Picture1
Picture1903×764 36.5 KB

Since you are using flowchart, it would be better to run the sequence based on the decision

Picture4
Picture4903×776 57.6 KB

3

Hi @Patil_Nivedita ,

Maybe you could check the below post, it does seem to have an Example ready. Let us know if this doesn’t align with your expectations :

4

@Patil_Nivedita You can also try with Repeat Number of Times activity within the flowchart

You can have the excel activities within activity and can run how many times you want. It’s just passing the number in the activity to define the number of times you run

Picture5
Picture5723×398 9.96 KB