I have the start date, end date and leave type, each in a variable. I need to type them into the next empty line and keep on appending. How do I do that?
Thanks in advance!
You can add those variables into a datatable…
Create the datatable with the required columns using build datatable.
Next, use add data row activity to add the variables as a array row to the table.
Use the array row property of the add data row activity to add the details to the table as follows
Now use append range activity to write the data to the next available row in the excel file