How to convert JSON array to CSV in Java?
Aug 21, 2023 pm 08:27 PM
JSON can be used as a data exchange format, it is lightweight and language independent. A JSONArray can parse a text string to produce an object similar to a vector, and supports the java.util.List interface. We can use the org.json.CDL class to convert the JSON array to CSV format, which provides a static method toString() for Convert JSONArray to comma separated text . We need to import the org.apache.commons.io.FileUtils package to store data in a CSV file using the writeStringToFile() method.
Syntax
public static java.lang.String toString(JSONArray ja) throws JSONException
In the below example, we can convert a JSON Array to CSV format.
Example
import java.io.File;
import org.apache.commons.io.FileUtils;
import org.json.*;
public class ConvertJsonToCSVTest {
public static void main(String[] args) throws JSONException {
String jsonArrayString = "{\"fileName\": [{\"first name\": \"Ravi\",\"last name\": \"Chandra\",\"location\": \"Bangalore\"}]}";
JSONObject output;
try {
output = new JSONObject(jsonArrayString);
JSONArray docs = output.getJSONArray("fileName");
File file = new File("EmpDetails.csv");
String csv = CDL.toString(docs);
FileUtils.writeStringToFile(file, csv);
System.out.println("Data has been Sucessfully Writeen to "+ file);
System.out.println(csv);
}
catch(Exception e) {
e.printStackTrace();
}
}
}Output
Data has been Sucessfully Writeen to EmpDetails.csv last name,first name,location Chandra,Ravi,Bangalore
The above is the detailed content of How to convert JSON array to CSV in Java?. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Detailed explanation of sorting and filtering operations of JSON arrays in Java.
Sep 06, 2023 pm 03:22 PM
Detailed explanation of sorting and filtering operations of JSON arrays in Java In Java development, processing JSON data is a common task. As one of the commonly used data structures, JSON array often requires sorting and filtering operations in practical applications. This article will introduce in detail the sorting and filtering operations of JSON arrays in Java and provide corresponding code examples. 1. Sorting operation of JSON array: Use JSONArray object to store JSON array in Java, and use json library to process JSON data
Get started quickly: JSON array merging and splitting techniques in Java.
Sep 06, 2023 am 10:21 AM
Get started quickly: JSON array merging and splitting techniques in Java In modern software development, data format and transmission have become increasingly important. Among them, JSON (JavaScriptObjectNotation) is a commonly used data format, especially suitable for front-end and back-end interaction and data storage. In Java development, we often need to deal with JSON objects and JSON arrays. This article explains how to merge and split JSON arrays in Java, along with tips and examples for implementing these operations.
Introduction to financial application development in Java language
Jun 10, 2023 pm 02:01 PM
Java language is a programming language widely used in the financial field. Due to its powerful functions and efficient performance, Java language has become the preferred language for financial institutions to develop software. This article will introduce the importance of Java language in financial application development and introduce some common financial applications. 1. Application of Java language in the financial field Java language has been widely used in the financial field. Its main advantages include: 1. Cross-platform capability. The Java language has cross-platform capability, which means that the same Java language
ChatGPT Java: How to build an accurate semantic search engine
Oct 24, 2023 am 10:21 AM
ChatGPTJava: How to build an accurate semantic search engine, requiring specific code examples. Introduction: With the rapid development of the Internet and the explosive growth of information, people often encounter poor quality and inconsistent search results in the process of obtaining the required information. Exact question. In order to provide more accurate and efficient search results, semantic search engines came into being. This article will introduce how to use ChatGPTJava to build an accurate semantic search engine and give specific code examples. 1. Understanding ChatGPTJ
Introduction to image processing algorithms in Java language
Jun 10, 2023 pm 10:03 PM
Introduction to image processing algorithms in Java language With the advent of the digital age, image processing has become an important branch of computer science. In computers, images are stored in digital form, and image processing changes the quality and appearance of the image by performing a series of algorithmic operations on these numbers. As a cross-platform programming language, Java language has rich image processing libraries and powerful algorithm support, making it the first choice of many developers. This article will introduce commonly used image processing algorithms in the Java language, and
How to use Java language to connect with Tencent Cloud API to send text messages
Jul 06, 2023 pm 10:01 PM
How to use Java language and Tencent Cloud API to implement SMS sending 1. Introduction With the rapid development of the mobile Internet, SMS notifications have become an important communication method between enterprises and users. Tencent Cloud provides a powerful SMS API service that can help developers quickly implement SMS sending functions. This article will introduce how to use Java language to connect with Tencent Cloud API to implement the SMS sending function. 2. Preparation: Register Tencent Cloud account, create SMS application, obtain API key (SecretId and SecretKey) 3
How to convert JSON array to CSV in Java?
Aug 21, 2023 pm 08:27 PM
JSON can be used as a data exchange format, it is lightweight and language independent. A JSONArray can parse text strings to produce vector-like objects and supports the java.util.List interface. We can convert JSON array to CSV format using org.json.CDL class, which provides a static method toString() for converting JSONArray to comma-separated text. We need to import the org.apache.commons.io.FileUtils package to store data in a CSV file using the writeStringToFile() method. Syntaxpublicstaticj
Introduction to smart agriculture application development in Java language
Jun 10, 2023 am 11:21 AM
With the development of the times, the agricultural field has also begun to upgrade and transform with the help of modern scientific and technological means, and smart agriculture has emerged as the times require. As a computer programming language with excellent performance and strong portability, Java has high popularity and application value, and has become one of the important solutions for smart agricultural application development. This article aims to introduce the development process, application scenarios and advantages of smart agricultural applications in Java language. 1. Development process of smart agricultural applications in Java language. The development process of smart agricultural applications is divided into requirements analysis,
