JSON API - mergeCells

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

mergeCells

PREMIUM

TRIAL / ADVANCED

Merges cells in the spreadsheet.

Note

You are reading the JSON API documentation. For the PHP API method please go to mergeCells.

JSON data

{
    "position": "string",
    "options": {
        "emptyExtraMergedCells": boolean
    }
}

Key	Description
position	Cell range to be merged: "A2:D2", "C2:E4"...
emptyExtraMergedCells	Empty merged cell contents from upper-left value. Default as true.

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "New cell"
                },
                "position": "A1"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Other cell"
                },
                "position": "A2"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Centered cell",
                    "bold": true,
                    "italic": true,
                    "underline": "single"
                },
                "cellStyles": {
                    "horizontalAlign": "center"
                },
                "position": "B5"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Cell content C5",
                    "color": "13775F"
                },
                "position": "C5"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Cell content C5",
                    "color": "13775F"
                },
                "position": "D5"
            }
        },
        {
            "action": "mergeCells",
            "data": {
                "position": "A1:C1"
            }
        },
        {
            "action": "mergeCells",
            "data": {
                "position": "B5:D5"
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.