JSON API - moveElement

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

moveElement

PREMIUM

TRIAL / ADVANCED

Moves elements in the spreadsheet.

Note

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

JSON data

{
    "referenceNode": {
        "type": "string",
        "contains": "string",
        "occurrence": number | "string" | array,
        "attributes": array,
        "customQuery": "string"
    },
    "referenceNodeTo": {
        "type": "string",
        "contains": "string",
        "occurrence": number | "string" | array,
        "attributes": array,
        "customQuery": "string"
    },
    "options": {
        "location": "string"
    }
}

Key	Description
type	sheet
contains	Contains a text string. Sheet type.
occurrence	(number) exact occurrence from 1 (array) occurrences (string) range of contents (e.g.: 2..9, 2.., ..9), first(), last()
attributes	Contains a specific attribute key and value.
customQuery	Custom XPath query, overwrites any other reference.
location	after (default) before

Code samples

Example #1

{
    "template": "template.xlsx",
    "actions": [
        {
            "action": "moveElement",
            "data": {
                "referenceNode": {
                    "type": "sheet",
                    "occurrence": -1
                },
                "referenceNodeTo": {
                    "type": "sheet",
                    "occurrence": 1
                }
            }
        }
    ]
}

A template can be a local file, a Base64 string, or a remote file.

Release notes

phpxlsx 6.0:
- new action.