How to write in the next empty cell?

Hello!
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!

Hi @SJL

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

{Variable1, variable2}

Now use append range activity to write the data to the next available row in the excel file

1 Like