Merge
Merges the selected cell range into a single cell or a cell row.
Syntax
expression.Merge(isAcross);
expression - A variable that represents a ApiRange class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| isAcross | Required | boolean | When set to -true, the cells within the selected range will be merged along the rows,\ but remain split in the columns. When set to -false, the whole selected range of cells will be merged into a single cell. |
Returns
This method doesn't return any data.
Example
This example merges the selected cell range into a single cell or a cell row.
- Code
- Result
let worksheet = Api.GetActiveSheet();
worksheet.GetRange("A3:E8").Merge(true);
worksheet.GetRange("A9:E14").Merge(false);