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(); } } ...
Read more

Map class field to map

-
 import java.lang.reflect.Field; import java.util.HashMap; import java.util.Map; public class AutogeneratedClassMapper {     public static Map<String, Object> mapFieldsToMap(Object obj) throws IllegalAccessException {         Map<String, Object> fieldMap = new HashMap<>();         Class<?> clazz = obj.getClass();         Field[] fields = clazz.getDeclaredFields();         for (Field field : fields) {             field.setAccessible(true);             Object value = field.get(obj);             fieldMap.put(field.getName(), value);         }         return fieldMap;     }     // Example usage     public static void main(String[] args) throws IllegalAccessException {         AutogeneratedClass au...
Read more