JSON API - addBreak

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

addBreak

PREMIUM

TRIAL / ADVANCED

Inserts a row or column break.

Note

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

JSON data

{
    "position": number,
    "type": "string"
}

Key	Description
position	1, 2, 5...
type	"row" or "col".

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "First content."
                },
                "position": "A1"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Next content."
                },
                "position": "A5"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Other content."
                },
                "position": "F10"
            }
        },
        {
            "action": "addBreak",
            "data": {
                "position": 2,
                "type": "row"
            }
        },
        {
            "action": "addBreak",
            "data": {
                "position": 4,
                "type": "row"
            }
        },
        {
            "action": "addBreak",
            "data": {
                "position": 5,
                "type": "col"
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.