JSON API - addSvg

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

addSvg

PREMIUM

TRIAL / ADVANCED

Inserts an SVG into the Excel spreadsheet.

Note

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

JSON data

{
    "svg": "string",
    "position": "string",
    "options": {
        "colOffset": {
            "from": number,
            "to": number
        },
        "colSize": number,
        "descr": "string",
        "editAs": "string",
        "dpi": number,
        "name": "string",
        "rotation": number,
        "rowOffset": {
            "from": number,
            "to": number
        },
        "rowSize": number
    }
}

Key	Description
svg	SVG path, or SVG content.
position	Cell position in the active sheet: "A1", "C3", "AB7"...
colOffset	"from" column size offset from. "to" column size offset to.
colSize	Number of columns used by the image.
descr	Descr value.
dpi	Dots per inch. Autodetect if not set.
editAs	Possible values are: "oneCell" (default): move but don't size with cells. "twoCell": move and size with cells. "absolute": don't move or size with cells.
name	Sets a name value.
rotation	60.000ths of a degree.
rowOffset	"from" row size offset from. "to" row size offset to.
rowSize	Number of rows used by the image.

Code samples

Example #1

{
    "actions": [
        {
            "action": "addSvg",
            "data": {
                "svg": "image.svg",
                "position": "A1",
                "options": {
                    "colSize": 3,
                    "rowSize": 7
                }
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.