JSON API - setRowSettings

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

setRowSettings

PREMIUM

TRIAL / ADVANCED

Sets row settings.

Note

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

JSON data

{
    "position": "string",
    "options": {
        "height": float,
        "hidden": boolean
    }
}

Key	Description
position	Row position in the active sheet: "1", "2"... "A1", "B3"...
height	Row height.
hidden	Hidden attribute.

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Lorem ipsum dolor sit amet"
                },
                "position": "A2"
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "4",
                "options": {
                    "height": 90.25
                }
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "2",
                "options": {
                    "height": 60
                }
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "3",
                "options": {
                    "height": 50.25
                }
            }
        },
        {
            "action": "addSheet",
            "data": {
                "name": "Other",
                "removeSelected": true,
                "selected": true,
                "active": true
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Sed ut perspiciatis unde omnis"
                },
                "position": "A1"
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "1",
                "options": {
                    "height": 40
                }
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "2",
                "options": {
                    "height": 50
                }
            }
        },
        {
            "action": "setRowSettings",
            "data": {
                "position": "3",
                "options": {
                    "height": 40
                }
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.