Transform JSON Into XLS | Java Community | Help. Code. Learn. | Page 1

safe thistle Aug 6, 2023, 4:58 PM

#

So basically I want to transform my JSON data into XLSX and return this file to my frontend. I was thinking about doing an API call to any transformer in internet, but I didn't find anyone. Do you know some API transformer or what can I do?

calm forgeBOT Aug 6, 2023, 4:58 PM

#

⌛ This post has been reserved for your question.

Hey @safe thistle! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

hexed cave Aug 6, 2023, 4:59 PM

#

..a structured object into a table?

#

how's that going to work?

safe thistle Aug 6, 2023, 5:04 PM

#

hexed cave how's that going to work?

You never seen before? It get the name of the fields and put each field into a column of the table

safe thistle Aug 6, 2023, 5:05 PM

#

hexed cave how's that going to work?

https://products.aspose.app/cells/conversion/json-to-xlsx this site is one of the transformers

Convert JSON to EXCEL Online for Free

JSON to EXCEL Converter

JSON to EXCEL Converter Online for Free.

hexed cave Aug 6, 2023, 5:05 PM

#

safe thistle You never seen before? It get the name of the fields and put each field into a c...

oh so only a single level deep?

#

or a top level array

#

i was thinking of more deeply nested data

safe thistle Aug 6, 2023, 5:06 PM

#

hexed cave i was thinking of more deeply nested data

It works with arrays too

#

try out

hexed cave Aug 6, 2023, 5:06 PM

#

nah

safe thistle Aug 6, 2023, 5:07 PM

#

make a list of JSON objects and download the file

#Transform JSON Into XLS