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

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

How to read CSV File in Java

-
Here we can learn how to read CSV file comma seprated in java below is the code --> Use apache API to read CSV or use BufferReader --> here i have used Buffer Reader import java.io.BufferedReader; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; /**  *  * @author anand  *  */ public class ReadCSVFile {     public static void main(String[] args) {               BufferedReader br = null;         String line = "";         String cvsSplitBy = ","; //Comma seprated         try {             br = new BufferedReader(new FileReader("Your_CSV_FILE_NAME"));             while ((line = br.readLine()) != null) {                 System.out.println("Content \t"+line);             }         } catch (Exception e) {             e.printStackTrace();         } finally {             if (br != null) {                 try {                     br.close();                 } catch (I
Read more