Create each sheet for sub elements/array in the json

Aspose.Cells Product Family
,
1

Hi Team,
I am able to convert json to excel but can I convert that in to multiple sheet based on the sub elements, give the scenario below how can I create separate sheet in excel for “test” array. Could you please help me on this?

{
“Event”:[
“status”: “Draft”,
“eventName”: “DummyTestPayload25049”,
“description”: “auto event configuration testings”,
“effectiveDate”: “”,
“isActive”: true,
“verDesc”: null,
“test”: [
{
“status”: null,
“testId”: null,
“dataKey”: “payload.notes”,
“dataValue”: “dummy20”,
“operator”: “Equals”,
“deleted”: false
}]
]
}

2

@Ravi25042504,

This is custom oriented requirement which other users won’t like/require this. So, we might not support it. The best way to cope with it, you may split your JSON data into multiple JSON files for your main and sub elements by yourselves. Then, create an empty workbook and add your desired number of worksheets in it. Now in each sheet, you may import relevant JSON file using the relevant APIs. See the document with example code on how to import JSON (file) data in a worksheet via JsonUtility.importData for your reference.

Hope, this helps a bit.

3

@Ravi25042504
Could you show an excepted result file , we will check it ASAP.