How to add data to Excel based on a template?

I have an Excel template that looks like this:


I have a datatable that has to be added based on the city how do I do this?

@Palaniyappan sir can you take a look at this? It’s a very urgent assignment for me

If I m right this was already raised and a logic was given,
Did we try with that buddy

Hi @cybzom
try this

Ashwin S

1 Like

its not dynamic sir

sir can u help me with this only pls?

First make a table only for BLR then write them in name and details coulmn
Then by using merge cells merge those cell depending on the rows count of BLR
Then similarly for the CHE , here u just need to keep count of entire sheet so that u can append the next area/state data.