How to merge excel using vb code in uipath

Help Activities
1

I need to merge particular range of cells to merge using vb code

2

Hi @sruthesanju

It can be done using invoke method activity

image

image

dt2 will be merged with dt1

3

Hi @sruthesanju ,

Any specific reason you are looking for vb code.

You can also use activity.
image

4

I need to merge cells in excel not in datatable

5

can you show be the input and output you want to display ?
You can attach any test file or screenshot here.

Thanks.

1 Like
6

@sruthesanju - you can try this…

image

image

7

I need merge cell range from b1:b6 the cell range may get differ

8

Try this.
MergeCells.xaml (5.3 KB)

9

IMG_20210719_210540
IMG_20210719_2105404000×1856 2.28 MB

Getting below mention issue

10

Have you passed correct file path and sheet name in arguments of invoke code

Is it possible for you to share the excel on which you are running ?

It’s working on my machine

11

Its working

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.