I have excel file which contain two sheet name one is i/p sheet and another is o/p sheet name.Now i/p sheet almost 5 k records.I am executing each records using for each loop.let suppose ten records executed I am inserting data of those ten records with some values in o/p sheet using add row then write range and also In input sheet name I created one column with the name of flag those records is executed so second run that record not execute.
Problem occur when I try to run second time o/p sheet records replace older records with new records.
I want when second run I am executing it insert data from 11 records in output sheet not from first.
You can use the ‘append range’ activity to insert records below the existing ones in the excel sheet.
Is this what you want?!