writetoevv
Board Regular
- Joined
- Mar 9, 2012
- Messages
- 71
- Office Version
- 2019
- 2010
- Platform
- Windows
Hi Friends
Would you please help to create below JSON file format from Excel/CSV via VBA.
a) Excel Snapshot with input data is provided for your reference.
b) Here is final sample output of JSON file for your reference
Thanks.
Would you please help to create below JSON file format from Excel/CSV via VBA.
a) Excel Snapshot with input data is provided for your reference.
b) Here is final sample output of JSON file for your reference
JSON:
[
{
"question":"150/3",
"question_title":"",
"question_image":"",
"wrong_answer_text":"",
"right_answer_text":"",
"question_hint":"",
"explanation":"",
"user_explanation":"",
"type":"radio",
"published":"1",
"create_date":"0000-00-00 00:00:00",
"not_influence_to_score":"",
"weight":"1",
"options":"",
"category":"Uncategorized",
"answers":[
{
"answer":"60",
"image":"",
"correct":"0",
"ordering":"1",
"weight":"1",
"keyword":"A",
"placeholder":""
},
{
"answer":"50",
"image":"",
"correct":"1",
"ordering":"2",
"weight":"2",
"keyword":"A",
"placeholder":""
},
{
"answer":"100",
"image":"",
"correct":"0",
"ordering":"3",
"weight":"1",
"keyword":"A",
"placeholder":""
}
]
},
{
"question":"10+20",
"question_title":"",
"question_image":"",
"wrong_answer_text":"",
"right_answer_text":"",
"question_hint":"",
"explanation":"",
"user_explanation":"",
"type":"radio",
"published":"1",
"create_date":"0000-00-00 00:00:00",
"not_influence_to_score":"",
"weight":"1",
"options":"",
"category":"Uncategorized",
"answers":[
{
"answer":"30",
"image":"",
"correct":"1",
"ordering":"1",
"weight":"2",
"keyword":"A",
"placeholder":""
},
{
"answer":"40",
"image":"",
"correct":"0",
"ordering":"2",
"weight":"1",
"keyword":"A",
"placeholder":""
},
{
"answer":"50",
"image":"",
"correct":"0",
"ordering":"3",
"weight":"1",
"keyword":"A",
"placeholder":""
}
]
}
]
Thanks.
Attachments
Last edited by a moderator: