JSON API - getCellPositions

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

getCellPositions

PREMIUM

TRIAL / ADVANCED

Gets existing cell positions from the active sheet.

Note

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

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Lorem ipsum dolor sit amet"
                },
                "position": "A1"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Lorem ipsum"
                },
                "position": "A2"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Sed ut perspiciatis unde omnis",
                    "italic": true,
                    "underline": "single"
                },
                "position": "B5"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "At vero eos et accusamus et iusto",
                    "color": "13775F"
                },
                "position": "F2"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Lorem ipsum dolor sit amet",
                    "bold": true,
                    "font": "Times New Roman",
                    "strikethrough": true
                },
                "position": "AA3"
            }
        },
        {
            "action": "getCellPositions"
        }
    ]
}

Example #2

{
    "template": "templates.xlsx",
    "actions": [
        {
            "action": "getCellPositions"
        }
    ]
}

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

Release notes

phpxlsx 6.0:
- new action.