How to add data to Excel based on a template?

[cybzom (Kiran Saminathan)]

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?

[cybzom (Kiran Saminathan)]

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

[Palaniyappan (Forum Leader)]

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

[AshwinS2 (Ashwin S)]

Hi @cybzom
try this

BalaReva.Excel.Activities

Hi Friends, I have included some new activities that merge and unmerge the cells Name Space : [image] Merge Cells - Merge the cells inside the excel file. Properties : [image] Sample File : MergeCells.zip (24.9 KB) UnMerge Cells- Unmerge the cells inside the excel file. Properties: [image] Sample : UnMergeCells.zip (24.8 KB) Let me know if you have any errors. I would be happy to get more suggestions Regards Balamurugan.S

Thanks
Ashwin S

[cybzom (Kiran Saminathan)]

its not dynamic sir

[cybzom (Kiran Saminathan)]

sir can u help me with this only pls?

[ImPratham45 (Prathamesh Patil)]

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.