Merge Excel cells in Faster way

[anjalimishra (Anjali)]

Hi,
Currently, I am trying to merge excel cell using excel shortcuts but it’s taking a lot of time to perform each merge.
The idea is to merge 6 cells together and perform the same activity 12 times horizontally and 15 times vertically.
Below is just a sample of the merge:
I would like to know if there is any faster way to perform the same?

Thanks,
Anjali

[Divyashreem (Divyashree Muddagangaiah)]

you can write a macro to merge cells and run macro from UiPath

[AshwinS2 (Ashwin S)]

Hi @anjalimishra
Please do see the below post

Search for column value and merge data cells

I have two excel sheets where one has duplicate ids with 1 more column and the other has only unique ids with 1 extra column. I want to merge them by searching for those unique ids from the second datatable in the first datatable. I have uploaded a sample file for better understanding.merge.xlsx (9.8 KB)

Thanks
Ashwin S

[balupad14 (Balamurugan)]

Hi @anjalimishra,

Please take a look this activity. It has facility to merge and un-merge the cells.

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

Regards
Balamuruga.S

[anjalimishra (Anjali)]

I tried opening MergeCells zip but it says “activity could not be loaded because of errors in the XAML”.

[balupad14 (Balamurugan)]

Hi @anjalimishra

Sorry I have attached the package that I have configured in the local. Again I will do the upload .

File : MergeCells.zip (8.7 KB)

Note : I have updated in the package thread also.

Thank you
BALAMURUGAN.S

[anjalimishra (Anjali)]

Thanks I have resolved it by invoking VB code