Create a loop for variables and write excel

Hi I would like to write my variables into excel sheet but in loop as my robot will be extracting data from email. Please help

first build data table with the column names yo want then use add data row activity
yo can give all the variables in {} separated by commas
and then use write range activity


Hope this helps


Welcome to the community

You have two options use weite cell and write each value independently


Build a datatable with required columns and Inside the loop first add the data to datatable ising add data row and passing variables as array row and then after loop use write range to write the data to excel