Merge excel rows and sum values

[gokulvasant]

Hi Guys, please check the following attachment, I would like to know how to merge excel rows and need sum the qty in excel. Try to help me out with this.

Thank you,
Gokul.

[balupad14 (Balamurugan)]

Hi @gokulvasant,

To merge the cells you can use this below actity.

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

After that to sum the quantity. use this acivity.

UiPath Go ! Datatable Activities

Hi All, Here you can get the datatable related activities. This package includes the below activities that can handle the Aggregation, Cumulative, Add - Delete row range and Export to Xml 1.Add Data Row Range. 2.Remove Data Row Select. 3.Group By Aggregation (Sum,Count,Avg, Max, Min). 4.DataTable to XML Document. 5.DataTable to XML File. 6.Sum,Count,Avg, Max, Min. Name Space [image] [image] https://go.uipath.com/component/datatable-related-activities Regards Balam…

UiPath datatable aggregation| change data type of data table| group by

Thank you
Balamurugan.S

[gokulvasant]

@balupad14, thank you very much, I got it.