JSON API - getCell

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

getCell

PREMIUM

TRIAL / ADVANCED

Gets cell information from the Excel spreadsheet.

Note

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

JSON data

{
    "position": "string",
}

Key	Description
position	Cell position in the active sheet: "A1", "C3", "AB7"...

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "Lorem ipsum dolor sit amet"
                },
                "position": "A1"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": 100
                },
                "position": "B1"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": "10.50"
                },
                "position": "B2"
            }
        },
        {
            "action": "addFunction",
            "data": {
                "function": "=SUM(B1:B2)",
                "position": "B3"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": 10.50
                },
                "position": "C1"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "A1"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "A2"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "B1"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "B3"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "C1"
            }
        }
    ]
}

Example #2

{
    "template": "template.xlsx",
    "actions": [
        {
            "action": "getCell",
            "data": {
                "position": "A6"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "C3"
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "C6"
            }
        },
        {
            "action": "setActiveSheet",
            "data": {
                "options": {
                    "position": 1
                }
            }
        },
        {
            "action": "getCell",
            "data": {
                "position": "B5"
            }
        }
    ]
}

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

Release notes

phpxlsx 6.0:
- new action.