Easy: parse Json into Excel table
New here? Learn about Bountify and follow @bountify to get notified of new bounties! x

VERY SIMPLE: Parse JSON into a specific format to display data in excel tables.

Description: I am providing you a sample JSON that is dynamic (number of items can change). Parse each flights (example has 34). And for each flight parse each segment (example has 1 or 2 segments per flight, but you can have more).

No browser involved in the solution. The input is a txt file with the Json in it, and the output is the excel table, in the same workbook as the vba code. The solution has to be programmed 100% in vba for excel. Use Json parser library for VBA: https://github.com/VBA-tools/VBA-JSON

SAMPLE JSON INPUT: https://www.dropbox.com/s/61xqutrw3xrjok9/ServerOutput.txt?dl=0

I need you display the data in an excel table as shown in the link:

SAMPLE EXCEL OUTPUT: https://www.dropbox.com/s/ku14hyn0mlae9i6/Sample%20output.xlsx?dl=0

SAMPLE EXCEL OUTPUT, WITH JSON LIBRARY ALREADY INSTALLED (in case you don't want to download it from the link above): https://www.dropbox.com/s/z7wnc3v0pc1a5a7/Sample%20output.xlsm?dl=0

Do you want a solution that works in the browser or would a command line tool (e.g. based on Node.JS) be work better for you?
kostasx 4 months ago
Tks for your comments. No browser involved. The input is a txt file with the Json inside, and the output is the excel table, in the same workbook as the vba code. The solution has to be programmed 100% in vba for excel. Use Json parser library for VBA: https://github.com/VBA-tools/VBA-JSON
MarkGrok 4 months ago
Hi Kostasx, I just posted some clarifications on the bounty.
MarkGrok 4 months ago

Crowdsource coding tasks.

1 Solution

Winning solution

Hi Mark!
I have just sent you a solution privately with the excel file.
I hope it works.

Let me know if you need any changes ;)