const hot = new Handsontable(document.getElementById('example'), {
 data: getData(),
 mergeCells: [
   {row: 0, col: 3, rowspan: 3, colspan: 3},
   {row: 2, col: 6, rowspan: 2, colspan: 2},
   {row: 4, col: 8, rowspan: 3, colspan: 3}
 ],

Methods

Source code

clearCollections()

Clears the merged cells from the merged cell container.

Source code

disablePlugin()

Disables the plugin functionality for this Handsontable instance.

Source code

enablePlugin()

Enables the plugin functionality for this Handsontable instance.

Source code

isEnabled(){boolean}

Checks if the plugin is enabled in the handsontable settings. This method is executed in Hooks#beforeInit
hook and if it returns true than the MergeCells#enablePlugin method is called.

Returns: {boolean}

Source code

merge(startRow, startColumn, endRow, endColumn)

Merges the specified range.

Parameters:

Name	Type	Description
startRow	number	Start row of the merged cell.
startColumn	number	Start column of the merged cell.
endRow	number	End row of the merged cell.
endColumn	number	End column of the merged cell.

Fires:

• Hooks#event:beforeMergeCells
• Hooks#event:afterMergeCells

Source code

mergeSelection(cellRange)

Merges the selection provided as a cell range.

Parameters:

Name	Type	Description
cellRange	CellRange	optional Selection cell range.

Source code

unmerge(startRow, startColumn, endRow, endColumn)

Unmerges the merged cell in the provided range.

Parameters:

Name	Type	Description
startRow	number	Start row of the merged cell.
startColumn	number	Start column of the merged cell.
endRow	number	End row of the merged cell.
endColumn	number	End column of the merged cell.

Fires:

• Hooks#event:beforeUnmergeCells
• Hooks#event:afterUnmergeCells

Source code

unmergeSelection(cellRange)

Unmerges the selection provided as a cell range.

Parameters:

Name	Type	Description
cellRange	CellRange	optional Selection cell range.

Source code

updatePlugin()

Updates the plugin state. This method is executed when Core#updateSettings is invoked.