Merging cells

[Pogboom]

I have this excel

Col A is the input format
Col B is the output which i need through UiPath
is there any activity to do this ? or do i need to write a VB code for the same

[Krishna_Raj]

@Pogboom

How to merge excel using vb code in uipath

Try this. MergeCells.xaml (5.3 KB)

check the reference

[pravallikapaluri]

@Pogboom

Col A is the input format
Col B is the output which i need through UiPath
is there any activity to do this ? or do i need to write a VB code for the same

Hi @Pogboom

PreviousValue = ""
For Each row in dtInput
    CurrentValue = row("ColA").ToString
    If CurrentValue = PreviousValue Then
        row("ColB") = PreviousValue & " " & CurrentValue
    Else
        row("ColB") = CurrentValue
    End If
    PreviousValue = CurrentValue
End For Each

[Pogboom]

getting error as remove unused imports

[Pogboom]

is this the vb code??

[pravallikapaluri]

@Pogboom

No use readrange workbook and store it in a dt var and then follow

@pravallikapaluri

PreviousValue = ""
For Each row in dtInput
    CurrentValue = row("ColA").ToString
    If CurrentValue = PreviousValue Then
        row("ColB") = PreviousValue & " " & CurrentValue
    Else
        row("ColB") = CurrentValue
    End If
    PreviousValue = CurrentValue
End For Each

[Pogboom]

not working exception thrown col B should be the output which i want through bot

[Shiva_Nikhil]

@Pogboom

refer this

forumquestion.zip (10.9 KB)

[Pogboom]

dt2 is not declared in this where is dt2 coming from ? reading forum excel file?

[Shiva_Nikhil]

@Pogboom

You can try this

forumupdatedcode.zip (11.7 KB)

[Pogboom]

not working where have you declared dt2?
can you share the output file image?

[Shiva_Nikhil]

@Pogboom
Sorry my mistake

in the write range output file you need to disable the option add headers

[Pogboom]

finaloutput is coming as empty sheet. can you please validate again

[Shiva_Nikhil]

@Pogboom

can you change the input file path in the read range activity and try once

[Pogboom]

what if i want to rewrite it in that first column only basically overwriting?

[Shiva_Nikhil]

@Pogboom

if you want to write it in the first column before to the write range activity use assign activity

And in the place of filepath use the input file path

[pravallikapaluri]

@Pogboom

If you find solution with mine,Please do mark mine as solution to close the loop