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?
you can write a macro to merge cells and run macro from UiPath
Please do see the below post
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)
Please take a look this activity. It has facility to merge and un-merge the cells.
I have included some new activities that merge and unmerge the cells
Name Space :
Merge Cells - Merge the cells inside the excel file.
Sample File :
MergeCells.zip (24.9 KB)
UnMerge Cells- Unmerge the cells inside the excel file.
Sample : UnMergeCells.zip (24.8 KB)
Let me know if you have any errors.
I would be happy to get more suggestions
I tried opening MergeCells zip but it says “activity could not be loaded because of errors in the XAML”.
Sorry I have attached the package that I have configured in the local. Again I will do the upload .
MergeCells.zip (8.7 KB)
Note : I have updated in the package thread also.
Thanks I have resolved it by invoking VB code