Duplicate Post. Refer answer in the same below link
As you know - there are different State in RE Framework. Do following actions mentioned below to achieve this
From INITIALIZATION State - Use Activity Build Data table and create a structure first. Use datatable variable to store the output. Scope of this data table should be the maximum
Inside PROCESS TRANSACTION State - Create an argument for passing datatable inside the Process.XAML. Direction should be in and out
Pass the datatable to Process.XAML. Inside Process.Xaml - After calculation - Once you identify all the values which are expected to add to excel file - Use below activity to add to Data table instead of excel writing. Use activity Add Data Row
Since you are passing the datatable which is created from the Initialization as both input and output - It will keep adding the rows during the run time
From Last END PROCESS STATE → Write the datatable back to excel
let me know if you are facing any challenges