Build a bot to create a excel file with records

Use Excel advance Package.

1.  Use create file option to create Excel file eg; Sample.xlsx
2. then Open that Excel file  using Open Excel command option
3. loop the records to assign to excel file 
4. use counter variable to to auto increment 

How do I loop the records to assign to excel and use counter variable to auto increment?