Converting JSONArray into CSV file in java

-
package com.loginController;

import java.io.File;
import org.apache.commons.io.FileUtils;
import org.json.CDL;
import org.json.JSONArray;
import org.json.JSONObject;
/**
 *
 * @author anand
 *
 */
public class ConvertArray {
    public static void main(String myHelpers[]){
        String jsonArrayString = "{\"fileName\": [{\"name\": \"Anand\",\"last\": \"Dwivedi\",\"place\": \"Bangalore\"}]}";

        JSONObject output;
        try {
            output = new JSONObject(jsonArrayString);


            JSONArray docs = output.getJSONArray("fileName");

            File file=new File("JSONSEPERATOR.csv");
            String csv = CDL.toString(docs);
            FileUtils.writeStringToFile(file, csv);
            System.out.println("Data has been Sucessfully Writeen to "+file);
        } catch (Exception e) {
            e.printStackTrace();
        }    
    }

}

Comments

  1. anoop12330 June 2017 at 05:27

    what is the file's location

    ReplyDelete
    Replies
    1. Anand Dwivedi 30 June 2017 at 05:30

      Thanks for referring this blog . File location in direct inside your Project . so you can copy JSONSEPERATOR.csv file inside your project

      Delete
  2. Unknown3 October 2017 at 03:50

    what if i want to take the json file instead of directly copying the json data into string?

    ReplyDelete
    Replies
    1. Anand Dwivedi 3 October 2017 at 04:54

      You have to write the code which reads JSON file content and assign into string then you can parse same string

      Delete
  3. Unknown3 October 2017 at 05:22

    Can u plz provide me the code snippet , explaining the same?

    ReplyDelete
    Replies
    1. Antrish26 February 2018 at 17:27

      Sushil.. asking the code snipped directly won't help you. Best way is to try something at your end and then ask for help here.Hope you will take it in a very positive context.

      Delete

Post a Comment

Popular posts from this blog

Java Design pattern

-
 Singleton Design pattern :-  it's Creational Design Pattern as we need to have only one instance of our class for Ex:- Logger,DBConnector. SingleObject class have its constructor as private and have a static instance of itself. Code:-  public class Singleton { private static Singleton object; private Singleton() { } public static synchronized Singleton getInstance() { if (object == null) object = new Singleton(); return object; } } Eager Initialization :-  public class Singleton { private static Singleton object = new Singleton(); private Singleton() { } public static Singleton getInstance() { return object; } } Double checked Locking :-  public class Singleton { private static volatile Singleton obj = null; private Singleton() { } public static Singleton getInstance() { if (obj == null) { synchronized (Singleton.class) { if (obj == null) obj = new Singleton(); } } return obj; } } W
Read more

Online Book Store Website Using Java

-
Image
=============================================== Login.html:- ================================================ <html>     <title>|| Login Page ||</title>     <body class="bod">         <form action='login.action'  method="post">             <table align='center'>                 <tr><td colspan='2' align='center'>                         <br></br>                         <h2 style="color: black; font-size: 30px; padding-top: 1%;" class="Head">User Login</h2></td></tr>                 <tr>                     <td><h2>UserName</h2></td>                     <td><input type='text' name='UserName' placeholder="UserName" autocomplete="off" required=""/></td></tr>                 <tr>                     <td><h
Read more