I have the following xml:
<root xmlns:json='http://james.newtonking.com/projects/json'>
<majorDimension>ROWS</majorDimension>
<range>Sheet6!A1:B2</range>
<values json:Array='true'>
<element json:Array='true'>
<element>Good</element>
<element>Value</element>
</element>
<element json:Array='true'>
<element>Hello</element>
<element>World</element>
</element>
</values>
</root>
and I'm using the following code:
var json = JsonConvert.SerializeXmlNode(xmlDoc, Newtonsoft.Json.Formatting.None, true);
The output that I am getting is like this
{
"majorDimension": "ROWS",
"range": "Sheet6!A1:B2",
"values": [
{ "element": [ [ "Good", "Value" ],
[ "Hello", "World" ] ]
}
]
}
However, I would like get an output something like this
{
"range": "Sheet6!A1:B2",
"majorDimension": "ROWS",
"values": [
[
"Good",
"Value"
],
[
"Hello",
"World"
]
]
}