Excel to Json and output to file

Let's say you want to do Excel JSON conversion and output the result to a file. Here's how

Sub ExCelToWebFile()
    Dim dSet As New cDataSet
    
    openNewHtml ActiveWorkbook.Path & "\yourfile.json", _
        dSet.populateData( _
        Range("jSon2!$a$1"), , , , , , True _
        ).jObject.serialize

End Sub

What's happening ?


For more like this see One Liners. Why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available. 

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.







Comments