In while loop I’m opening. One excel file and adding some data to worksheet.How should I add data at sequential worksheets one by one ?My data is going now only on first sheet .Its not shifting to other sheets (I have also mentioned worksheet number)
@priyanka_tambe Try to use Variable for the sheet name. And use this variable inside the write range activity. Update the value of this variable for every iteration.