convert json file to excel sheet or csv in java

Asked Aug 30 '18 at 05:28

Active Aug 30 '18 at 06:37

Viewed 136 times

{
    "firstName": "John",
    "lastName": "Smith",
    "address": [
      {
        "streetAddress": "21 2nd Street",
        "city": "New York",
        "state": "NY",
        "postalCode": "0021"
      }
    ],
    "age": 25,
    "phoneNumbers": [
      {
        "type": "home",
        "number": "212 555-1234"
      },
      {
        "type": "fax",
        "number": "212 555-1234"
      }
    ]
  }

take this as an json file and as an input and convert it to the excel sheet..? i am getting difficulty in parsing the json array.

edited Aug 30 '18 at 06:37

Derrick

3,669
5
35
50

asked Aug 30 '18 at 05:28

shashank

1

Welcome to Stack Overflow! What have you tried so far? – Glains Aug 30 '18 at 05:32
1

Maybe you skip the parsing-by-yourself and look for a json-library that does it for you. – Ralf Renz Aug 30 '18 at 05:56
Try this https://stackoverflow.com/questions/7172158/converting-json-to-xls-csv-in-java – Chidambaram Aug 30 '18 at 06:40

convert json file to excel sheet or csv in java

0 Answers0