Exporting details from excel to json string



  • I have followed your nice example on how to convert excel details into Json, now I only a little bit of help on the format . For example I have the excel details below , now I want to export to Json String as stated next page below , how can it be archieved?????

    Json Data Required:

    {
    "Customer":"James"
    "Address":"Revonia"
    "Items":[
    {
    "itemid":1,
    "description":"Milk"
    "Barcode":"786000036"
    "Quantity":6,
    "Rebate":0,
    "Price":20,
    "VAT":[
    "T",
    "Z"
    ],
    "Total":120,
    "Taxinclusive":No,
    "SpecialPrice":0
    }
    ]
    }

    EXCEL DATA SPREADSHEET:

    Customer Address Items Description Bar-code Quantity Rebates Price VAT T Z
    James Revonia Milk 786000 6 0 20

    Total Tax-inclusive Special Price
    120 No 0

    Basically its all about placing the square brackets ([ ]) & Curly Braces ({ } )as per required Json format above

    I have tried the above I cannot get the [ ] & { } correct through your VBA code, is there something I'm doing wron


Log in to reply
 

Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.