Hello guys,
I have a procedure that converts a JSON String into an Object. This has been working just great for years and I don't have a problem with that. NOW, I want build exactly the opposite. I want to build a JSON String out of personalized Object created from a class.
Is there a way to do it? Do you guys have a sample that can show me?
Appreciate your help,
1 Or 0, that is the question.
Well, two things:
1. What is A JSON string?
2. Could you please attach a sample workbook.
Maybe a workbook isn't necessary depending on what the definition of a JSON string is.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
JSON String is the full text that represent the JSON Object.
More likely to get some ideas from
http://ramblings.mcpher.com/Home/exc...ks/classeslink
I normally don't use json. I just get a string from a web service and then parse it.
This might have something for you. http://ramblings.mcpher.com/Home/excelquirks/json
This meant
http://ramblings.mcpher.com/system/a...ch-site&q=JSON
I have never played with JSON as it does not work with excel 64 bits
Thank you @AB33. I already looked there and yes, there are some things that can be considered.
I usually get the string and parse it out in VBA into an Object. But now I need to get the Object in VBA and parse it into a String.
What's the object?
Personalized class object with properties that I built myself.
You'll need to serialize it manually, there's no reflection built into vba so you can't get the properties at runtime
What you mean? Put it in a dictionary/collection?You'll need to serialize it manually
Sort of, I think you'll need to map your object to dictionaries and arrays, you can then use the code here to convert it to JSON
https://github.com/VBA-tools/VBA-JSO...nConverter.bas
A THOUSAND LINES OF CODE!!! That looks like an easy task to go through...Thank you!!!
You don't need to go through it, just stick it in a module and call the function
I was just going through the code and it's great. I think I can work with this. You and whoever wrote this. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks