Reputation: 903
I have a response in JSOn format, is there any way that I can convert it into excel sheet with a click of button in my page?
["abcd","business desc ","John","Analyst","[email protected]","(xxx)xxx-xxxx","2","167600"]
Thanks!
Upvotes: 2
Views: 1028
Reputation: 1598
This is not a difficult task at all. The development section of excel provides you with a pretty basic IDE to use with Visual Basic for Application (VBA). Here is a link to a simple class library that I have used once:
http://www.ediy.co.nz/vbjson-json-parser-library-in-vb6-xidc55680.html
Its simple as it uses the native objects to VBA to deal with JSON format.
Upvotes: 2