Dynamically add rows when dumping data into excel

[abdeleon]

Hi,

I’m trying to figure out how do I dynamically add rows to excel. I have an excel template where I would dump(paste) the data from another excel file, I can do that however, the problem is that some files exceeds the number of rows allocated to it.

As you can see, my template only has a limited numbers of rows for each kind of ‘ticket’ (I filled the cells with color yellow to indicate that those are the cells that have values), what I want to happen is that it dynamically add more rows based on the number of rows that needs to be dumped into the template.

Would be very grateful if you can help me with this one. Thanks!

Regards,
Arvs

[Palaniyappan (Forum Leader)]

@abdeleon

what I want to happen is that it dynamically add more rows based on the number of rows that needs to be dumped into the template.

Fine
welcome to UiPath community
we can use INSERT/DELETE ROWS activity to insert required no of rows to a excel with mentioned position and no of rows needed

Activities - Insert/Delete Rows

Cheers @abdeleon