TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

UnMerge

UnMerge()

Splits the selected merged cell range into the single cells.

Parameters:

This method doesn't have any parameters.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A3:E8").Merge(true);
oWorksheet.GetRange("A5:E5").UnMerge();
builder.SaveFile("xlsx", "UnMerge.xlsx");
builder.CloseFile();

Resulting document