Share
Report
13Hello,
I trying to get info out off some xml files and I'm changing the files in json format, and then when I'm trying to parse it will error out. Any help is much appreciated. Thanks
With schema:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"ss:Table": {
"type": "object",
"properties": {
"ss:Row": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ss:Cell": {
"type": "object",
"properties": {
"ss:Data": {
"type": "object",
"properties": {
"#text": {
"type": "string"
},
"@ss:Type": {
"type": "string"
}
}
}
}
},
"@ss:AutoFitHeight": {
"type": "string"
}
},
"required": [
"@ss:AutoFitHeight",
"ss:Cell"
]
}
},
"@ss:ExpandedColumnCount": {
"type": "string"
},
"@ss:ExpandedRowCount": {
"type": "string"
},
"@x:FullColumns": {
"type": "string"
},
"@x:FullRows": {
"type": "string"
},
"@ss:DefaultColumnWidth": {
"type": "string"
},
"@ss:DefaultRowHeight": {
"type": "string"
}
}
},
"WorksheetOptions": {
"type": "object",
"properties": {
"PageSetup": {
"type": "object",
"properties": {
"Header": {
"type": "object",
"properties": {
"@Margin": {
"type": "string"
}
}
},
"Footer": {
"type": "object",
"properties": {
"@Margin": {
"type": "string"
}
}
},
"PageMargins": {
"type": "object",
"properties": {
"@Bottom": {
"type": "string"
},
"@Left": {
"type": "string"
},
"@Right": {
"type": "string"
},
"@Top": {
"type": "string"
}
}
}
}
},
"Unsynced": {},
"Selected": {},
"Panes": {
"type": "object",
"properties": {
"Pane": {
"type": "object",
"properties": {
"Number": {
"type": "string"
},
"ActiveRow": {
"type": "string"
},
"ActiveCol": {
"type": "string"
}
}
}
}
},
"ProtectObjects": {
"type": "string"
},
"ProtectScenarios": {
"type": "string"
},
"@xmlns": {
"type": "string"
}
}
},
"@ss:Name": {
"type": "string"
}
},
"required": [
"@ss:Name",
"ss:Table",
"WorksheetOptions"
]
}
}
Categories:
I have the same question (0)
All responses (
Answers (
