Create a report in excel inside for loop

Learn
1

Hi,In previous I have done.I have input excel file after processing all record in for loop then it move outside fir loop and create new report As mention in attachment

Untitled
Untitled1440×900 64.5 KB
.Now I want when the record is process inside for loop.it create new sheet and insert data in this sheet for each and every record.

2

if you want this to create a new sheet for every loop just make sheet name as variable and move this excel application scope to inside for loop, and make sure you update the sheet name variable name always(for each loop).

3

thanks for reply sheet create only one time and insert data one by one in excel file.
eg I have 10 records in for loop
it create new excel sheet.Now for loop process 1st record after process complete. this will add record in newly created sheet.Then move to second record after process it will add second record in newly existing excel sheet.so on…
Hope you understand my requirement if not let me know

4

Then use write cell activity outside loop and just write the header’s and then use append range activity inside for loop.

5

@Aditya10989

When you move excel scope into the loop:

  1. The “Sheet1” will be created only in first time if robot cannot found it in excel file. In next loop, it won’t create anymore
  2. You must update Cell variable for each loop to append data to the end of sheet