Home > Software engineering >  How to create a standalone application to convert JSON file data to Excel by using java
How to create a standalone application to convert JSON file data to Excel by using java

Time:11-24

I'm new to IT Industry and My lead gave a Task to convert JSON file which contains JSON arrays, objects and Nested with 4000 lines to convert into Excel sheet in locally by reading JSON file. Please help me fellow coders.

CodePudding user response:

There is a lot to unpack here. You are asking for instructions to build a Java Application without providing much context regarding the entire use case. There are a lot of different ways to approach your problem.
If you are new to Spring-Boot, I'd suggest reading the documentation.

It hopefully will provide you with a basic understanding of the core concepts.

Now lets get to the JSON-to-XLS conversion. According to this question, it is recommended to convert your JSON-Data into the CSV format. CSV could be interpreted as an open alternative to xls for tabular data. As far as I'm aware, Excel can open CSV files.

CodePudding user response:

If you share the json file contents, then It will be easier to convert that to a excel file. or If you think that file is confidential, You can share some sample file like the JSON real file

  • Related