Skip to content

Merge/Unmerge Cells Activity

The Merge/Unmerge Cells activity enables users to combine or separate cells within an Excel worksheet. This activity provides control over cell layout, allowing for structured data presentation or restoration of individual cell formatting.

Field Description Requirement
Excel name The reference name of the Excel file that has already been opened or created. Required
Sheet name The name of the sheet to work in Excel. If not specified, the first sheet is used by default. Optional
Sheet index The index of the sheet to work in Excel. If not specified, the first sheet is used by default. Optional
Range The specific Excel sheet range (e.g., "A1:D7") for the merge or unmerge operation. Required
Merge cells? Select this checkbox to merge cells. Deselect it to unmerge cells. Required

Action Types & Examples

Merge Operation

  • Format: Boolean
  • Example Result: true (when the 'Merge cells?' parameter is selected)

Unmerge Operation

  • Format: Boolean
  • Example Result: false (when the 'Merge cells?' parameter is deselected)

Implementation Examples

Field Setup - Excel name: newExcel - Sheet name: Sheet1 - Sheet index: 5 - Range: A1:D7 - Merge cells?: true

Execution Parameters - ExcelName: newExcel - SheetName: "Sheet1" - SheetIndex: 5 - CellRange: "A1:D7" - MergeCells: true

Technical Notes

If the Sheet name field is left blank, the activity defaults to the first sheet of the Excel file. If the Range field is not specified, the activity will apply to all data within the Excel file.