web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to merge a cell in...

Power Automate

Unanswered

How to merge a cell in excel using Power Automate Desktop

(0) Share

Report

Report

Posted on by Shanmugapriya09

10

I need output in the below format in excel, how to perform using Power Automate desktop

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

kinuasa 795 Most Valuable Professional on at

Like (1)

Report
Hi,
Power Automate for desktop does not provide a dedicated action for merging cells.
For stable processing, I recommend using a script only for the cell merging part as shown below.

Open the workbook. (Launch Excel or Attach to running Excel action)

Activates a specific worksheet. (Set active Excel worksheet action)

Selects a range of cells or a named cell in the active worksheet. (Select cells in Excel worksheet action)

Execute the following script to merge the cells. Please change the workbook path in the code. (Run VBScript action)

With GetObject("C:\hoge\hoge.xlsx").Application .DisplayAlerts = False .CommandBars.ExecuteMso "MergeCells" .DisplayAlerts = True End With

or

With GetObject(, "Excel.Application").Application .DisplayAlerts = False .CommandBars.ExecuteMso "MergeCells" .DisplayAlerts = True End With

Regards,
kinuasa

Was this reply helpful? Yes No

Join the conversation