Parsing data from JSON file to excel sheets using VBA

Viewed 26

The project I'm working on is basically generating a time table/ schedual using JSON data from a file. Whats the best way to extract data from JSON file to an excel sheet?

enter image description here

I'm aiming to make the excel sheet look like this. and the JSON file will look like this

 "BIOM4070": {
    "sections": {
        "0101": {
            "term": "Fall 2022",
            "status": "Closed",
            "name": "BIOM*4070*0101 (6927) Biomedical Histology",
            "location": "Guelph",
            "meetings": [
                {
                    "LEC Tues, Thur": {
                        "meetingType": "LEC Tues, Thur",
                        "meetingTime": "11:30AM - 12:50PM",
                        "location": "MCKN, Room 029"
                    }
                },
                {
                    "LAB Wed": {
                        "meetingType": "LAB Wed",
                        "meetingTime": "02:30PM - 05:20PM",
                        "location": "MINS, Room 017"
                    }
                },
                {
                    "EXAM Tues": {
                        "meetingType": "EXAM Tues",
                        "meetingTime": "08:30AM - 10:30AM (2022/12/13)",
                        "location": "TBA, Room TBA"
                    }
                }
            ],
            "faculty": "R. Sabry",
            "capacity": "0 / 40",
            "credits": "0.50",
            "level": "Undergraduate"
        },

I need to only grab certain data like the timing so i can create a macro that generates a a schedule

0 Answers
Related