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
regards,
Usha
Welcome to the community
You have two options use weite cell and write each value independently
Or
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
Cheers