Plz help me to solve the usecase

i have a n excel with coloumns of NO, NAME, COUNTER
if the counter has value of 5 … then we have to create the ouput xlsx file with 5 rows
how can do that

@katta_nikhil ,
Can you please share the sample Input File and the Output .



Use a if condition like
Counter = 5
If true in then block then use a WHILE ACTIVITY with condition like this

Repeatcounter < counter
Where Repearcounter is a variable of type int32 with default value as 0 defined in variable panel

Inside the loop use a
ADD DATAROW activity like this to add a empty row

And use a assign activity like this to incremental the repeat counter value

Repeatcounter = Repeatcounter + 1

Cheers @katta_nikhil

output.xlsx (10.9 KB)
testdata.xlsx (8.4 KB)

Hey @katta_nikhil ,
Please check this workflow (2.4 KB)

Output :



thankyou i can modify this

1 Like

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