XMLTOJSON

Syntax: CS.SPARK_XMLTOJSON(cellAddressOrValue)

Convert an XML string into JSON and return it as string.

Parameter	Description
cellAddressOrValue *	Either the address of the cell that contains XML or XML string.

Example

Copy the example XML data below and paste it into the cell A1 of a new worksheet.

<note>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Don't forget me this weekend!</body>
</note>

Paste the custom function below and paste it into A2:

=CS.SPARK_XMLTOJSON(A1)

You should get the following result:

{
    "note": {
        "to": "Tove",
        "from": "Jani",
        "heading": "Reminder",
        "body": "Don't forget me this weekend!"
    }
}