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!