JSON API - addMathEquation

CONTENTS

LAYOUTS

TEMPLATES

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

watermark

PERFORMANCE

zipStream

addMathEquation

PREMIUM

TRIAL / ADVANCED

Adds math equations into the Excel spreadsheet.

Note

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

JSON data

{
    "equation": "string",
    "type": "string",
    "position": "string",
    "equationStyles": {
        "align": "string",
        "color": "string",
        "fontSize": number
    }
    "options": {
        "colOffset": {
            "from": number,
            "to": number
        },
        "colSize": number,
        "editAs": "string",
        "name": "string",
        "rowOffset": {
            "from": number,
            "to": number
        },
        "rowSize": number
    }
}

Key	Description
equation	OMML equation string or MathML.
type	Type of equation: omml, mathml.
position	Cell position in the active sheet: "A1", "C3", "AB7"...
align	left, center, right.
color	Hexadecimal color value: "FF0000", "000000"...
fontSize	8, 9, 10...
colOffset	"from" column size offset from. "to" column size offset to.
colSize	Number of columns used by the text box.
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.
rowOffset	"from" row size offset from. "to" row size offset to.
rowSize	Number of rows used by the text box.

Code samples

Example #1

{
    "actions": [
        {
            "action": "addMathEquation",
            "data": {
                "equation": "<m:oMathPara xmlns:m=\"http://schemas.openxmlformats.org/officeDocument/2006/math\"><m:oMath><m:r><m:t>∪±∞=~×</m:t></m:r></m:oMath></m:oMathPara>",
                "type": "omml",
                "position": "B2",
                "options": {
                    "colSize": 2,
                    "editAs": "twoCell"
                }
            }
        }
    ]
}

Example #2

{
    "actions": [
        {
            "action": "addMathEquation",
            "data": {
                "equation": "<math xmlns=\"http://www.w3.org/1998/Math/MathML\"><mrow><mi>A</mi><mo>=</mo><mfenced open=\"[\" close=\"]\"><mtable><mtr><mtd><mi>x</mi></mtd><mtd><mn>2</mn></mtd></mtr><mtr><mtd><mn>3</mn></mtd><mtd><mi>w</mi></mtd></mtr></mtable></mfenced></mrow></math>",
                "type": "mathml",
                "position": "C3",
                "options": {
                    "colSize": 3,
                    "rowSize": 3
                }
            }
        }
    ]
}

Release notes

phpxlsx 6.0:
- new action.