Sanju
Sanju

Reputation: 903

JSON format to excel

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

Answers (1)

Joseph Pla
Joseph Pla

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

Related Questions