How to export json arrays to Excel

This article is to share with you about how to export the json array to Excel, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Export method public static JSONObject createExcel (String src, JSONArray json) {/ / message used to return response JSONObject result = new JSONObject (); try {File file = new File (src); file.createNewFile (); OutputStream outputStream = new FileOutputStream (file); WritableWorkbook writableWorkbook = Workbook.createWorkbook (outputStream); WritableSheet sheet = writableWorkbook.createSheet ("First sheet", 0) / / set the border WritableFont font = new WritableFont (WritableFont.TIMES, 10, WritableFont.NO_BOLD, false); WritableCellFormat format = new WritableCellFormat (font); format.setBorder (jxl.format.Border.ALL, BorderLineStyle.THIN); format.setAlignment (Alignment.CENTRE); JSONArray jsonArray = json; Label label;// cell object int column = 0 / / column count JSONObject first = jsonArray.getJSONObject (0); Iterator iterator = first.keys (); while (iterator.hasNext ()) {String key = iterator.next (); label = new Label (column++, 0, key, format); sheet.addCell (label);} for (int I = 0 I < jsonArray.size (); iTunes +) {JSONObject item = jsonArray.getJSONObject (I); iterator = item.keys (); column = 0; while (iterator.hasNext ()) {String key = iterator.next (); String value = item.getString (key) Label = new Label (column++, (I + 1), value, format); sheet.addCell (label);}} writableWorkbook.write (); writableWorkbook.close ();} catch (Exception e) {result.put ("result", "failed") Result.put ("reason", e.getMessage ()); return result;} result.put ("result", "successed"); return result;} Test method public static void main (String [] args) {String src = "C:\\ a.xls" String str = "[{\" dupCount\ ": 4,\" qs_sumValue\ ": 30,\" qs_span\ ": 16,\" qs_dupCount\ ": 0,\" sumValue\ ": 64,\" dxb\ ":\" 2:6\ ",\" job_qs\ ":\" 2:1\ ",\" winNumber\ ":\" 19 03 08 06 12 01 10\ ",\" zhb\ ":\" 4:4\ ",\" matchNo\ ":\" 17122387\ " \ "zhb_qs\":\ "2:1\",\ "job\":\ "4:4\",\ "dxb_qs\":\ "1:2\",\ "span\": 18}, {\ "dupCount\": 4,\ "qs_sumValue\": 36,\ "qs_span\": 14,\ "qs_dupCount\": 1,\ "sumValue\": 70,\ "dxb\":\ "3:5\",\ "job_qs\":\ "0:3\" \ "winNumber\":\ "20 10 06 11 15 01 02 05\",\ "zhb\":\ "4:4\",\ "matchNo\":\ "17122386\",\ "zhb_qs\":\ "0:3\",\ "job\":\ "4:4\",\ "dxb_qs\":\ "1:2\",\ "span\": 19}, {\ "dupCount\": 5,\ "qs_sumValue\": 32,\ "qs_span\": 13 \ "qs_dupCount\": 0,\ "sumValue\": 57,\ "dxb\":\ "1:7\",\ "job_qs\":\ "2:1\",\ "winNumber\":\ "19 07 06 10 01 02 03 09\",\ "zhb\":\ "5:3\",\ "matchNo\":\ "17122385\",\ "zhb_qs\":\ "2:1\",\ "job\":\ "5:3\" \ "dxb_qs\":\ "1:2\",\ "span\": 18}, {\ "dupCount\": 6,\ "qs_sumValue\": 15,\ "qs_span\": 10,\ "qs_dupCount\": 1,\ "sumValue\": 46,\ "dxb\":\ "1:7\",\ "job_qs\":\ "3:0\",\ "winNumber\":\ "11 01 03 08 10 02 06\" \ "zhb\":\ "5:3\",\ "matchNo\":\ "17122384\",\ "zhb_qs\":\ "3:0\",\ "job\":\ "4:4\",\ "dxb_qs\":\ "1:2\",\ "span\": 10}, {\ "dupCount\": 0,\ "qs_sumValue\": 27,\ "qs_span\": 5,\ "qs_dupCount\": 0,\ "sumValue\": 46 \ "dxb\":\ "1:7\",\ "job_qs\":\ "1:2\",\ "winNumber\":\ "10 11 06 04 05 01 02 07\",\ "zhb\":\ "5:3\",\ "matchNo\":\ "17122383\",\ "zhb_qs\":\ "1:2\",\ "job\":\ "4:4\",\ "dxb_qs\":\ "1:2\",\ "span\": 10} "" JSONArray jsonArray = JSONArray.fromObject (str); JSONObject jsonObject1 = createExcel (src, jsonArray); if (! JSONUtils.isNull (jsonObject1.get ("result") {String result = jsonObject1.get ("result"). ToString (); if ("failed" .equals (result)) {System.out.println (jsonObject1.get ("reason")) The above is how to export the json array to Excel. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.