How to loop and write

here first some columns data is there and after doing some operation, will populate the data. Considering the last column I need to write case where number of rows

So it a static template with first column and you are adding data to it?

yes it is static template, but how many rows are there that should write attaching case

eg:2 rows then next should be Case2 in the first row of the 2 rows,
4 rows then it should be case4 in the first row of 4 rows.

you can find image above

Hi Sharanabasava1,
Use this workflow
Sample.xaml (10.5 KB)
FinalData.xlsx (9.3 KB)

I hope it will work for uou




it should write first consecutive of the rows and {10,6,7,8,9,3} it has written Case6 at number “9”

Thank you

and getting output like this for some of the inputs

I am attaching input file and in one column I have given expected output, how data is required
FinalData .xlsx (9.4 KB)


I finally understood your requirement :open_mouth:. But still the output will be displayed in the last row of the set as bot needs to read the continuous non empty rows and then only it can write it.

This the output you will get with this xaml:

Main.xaml (13.1 KB)


Thank you Rajeswari

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.