How to convert jsonarray data to excel in java

Question

Have a requirement where jsonarray data is to be converted and written in an excel file in JAVA. Below is a sample format of the JSON that i receive from the rest api of a marketing tool ActOn:

{
"offset":0,
"count":3,
"totalCount":300,
"result":[
{
"a1":a,
"b1":b,
"c1":c
},
{
"a2":a,
"b2":b,
"c2":c
},
{
"a3":a,
"b3":b,
"c3":c
},
.
.
.
.
.
.
,
{
"an":a,
"bn":b,
"cn":c
}
]

Easiest way is to create a csv file which excel can then read — Lance Toth, Mar 13 '18 at 09:15
Take a look into [example](https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/) — Victor Gubin, Mar 13 '18 at 09:16
Take a look at [this](https://stackoverflow.com/a/15411074/9085612) answer, maybe it can help you. — alexleo2000, Mar 13 '18 at 09:20
Possible duplicate of [Converting JSON to XLS/CSV in Java](https://stackoverflow.com/questions/7172158/converting-json-to-xls-csv-in-java) — OcelotcR, Mar 13 '18 at 09:23

score 0 · Answer 1 · answered Mar 13 '18 at 09:21

0

You can use CSV format instead of xml or xmls. CSV Format Specification So, you don't need any specific libraries and so on. Just use \n to split rows and , to split columns.

answered Mar 13 '18 at 09:21

Roman Dzhadan

168
1
8

How to convert jsonarray data to excel in java

1 Answers1