Skip to main content

Merge Cells

Description​

This Activity facilitates merging designated cell ranges within an Excel spreadsheet, accommodating adjacent and non-adjacent cells with properties customizable to user preferences.

Properties​

Input​

  • Cells – Specify the range of cells you want to merge.
  • Spreadsheet – Specify the Workbook instance where you want to merge cells.

Optional​

  • Continue On Error – This property determines whether the automation should persist in execution even if the Activity encounters an error. When set to True, the Activity proceeds without raising any exceptions. Conversely, when set to False, the Activity will raise an exception. The default setting is False.
note

When you enclose this Activity within a Try-Catch block and set the value of this property to True, it will not capture the error.

  • Sheet Name – Specify the sheet's name where you wish to merge the cells. By default, the operation will apply to the currently active sheet.

Misc​

  • DisplayName – Add a display name to your Activity.
  • Private – By default, Activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Example​

Download Example

Merge Cells Example