JSON API - addDefinedName

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

addDefinedName

PREMIUM

TRIAL / ADVANCED

Adds defined names into the Excel spreadsheet.

Note

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

JSON data

{
    "name": "string",
    "value": "string",
    "options": {}
}

Key	Description
name	Defined name.
value	Defined name value.

Code samples

Example #1

{
    "actions": [
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": 100
                },
                "position": "A2"
            }
        },
        {
            "action": "addCell",
            "data": {
                "contents": {
                    "text": 10.50
                },
                "position": "A3"
            }
        },
        {
            "action": "addDefinedName",
            "data": {
                "name": "MY_SUM",
                "value": "Sheet1!$A$2:$A$3"
            }
        },
        {
            "action": "addFunction",
            "data": {
                "function": "=SUM(MY_SUM)",
                "position": "D3",
                "contentStyles": {
                    "bold": true,
                    "font": "Arial"
                },
                "cellStyles": {
                    "background": "FFFF00",
                    "verticalAlign": "top"
                }
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.