Xml в csv на java

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

java read big xml file and convert to csv

gtiwari333/java-read-big-xml-to-csv

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

This uses Java SAX parser to parse a big xml file efficiently and convert to csv file

First, import into Intellij as Maven project. Make sure you have maven

Requirement: make sure you have java installed (run java -version )

Generate Jar file — it will be generated in target folder

java -jar target\xmltocsv-FINAL.jar C:\folder\input.xml C:\folder\output.csv

File: 118MB big2.xml @ 16GB Ram, Core i5, 6MB L3 cache, SSD

Included xml files — unzip before use

• small.xml — 1.44KB file
• big1.zip — 2MB file
• big2.zip — 118MB file
• big3.7z — 6.58GB file

Native Image with GraalVM

Run the following to generate native image

mvn clean package native-image:native-image

$ ./target/xmltocsv ../big2.xml ../big2.csv 

About

java read big xml file and convert to csv

Источник

Programming for beginners

    Rama Krishna Ponnam 33   Sowmya Krishna Ponnam 25   

  version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" >  method="text" omit-xml-declaration="yes" indent="no"/>  match="/">firstname,middlename,lastname,age  select="/students/student">  select="concat(firstname,',',middlename,',',lastname,',',age,'
')"/>    

package com.sample.app; import java.io.File; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.transform.Result; import javax.xml.transform.Source; import javax.xml.transform.Transformer; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import javax.xml.transform.stream.StreamSource; import org.w3c.dom.Document; public class App  public static void main(String args[]) throws Exception  File stylesheet = new File("/Users/krishna/Documents/studentData.xsl"); File xmlSource = new File("/Users/krishna/Documents/studentData.xml"); DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); DocumentBuilder builder = factory.newDocumentBuilder(); Document document = builder.parse(xmlSource); StreamSource stylesource = new StreamSource(stylesheet); Transformer transformer = TransformerFactory.newInstance().newTransformer(stylesource); Source source = new DOMSource(document); Result outputTarget = new StreamResult(new File("/Users/krishna/Documents/result.csv")); transformer.transform(source, outputTarget); > > 

firstname,middlename,lastname,age Rama,Krishna,Ponnam,33 Sowmya,Krishna,Ponnam,25

Источник

Convert XML File to CSV in Java using REST API

XML (eXtensible Markup Language) is a markup language for storing, transmitting, and reconstructing data between different applications. CSV (Comma Separated Values), on the other hand, is a simple file format designed to store tabular data. Sometimes, it can be difficult to manage when dealing with large amounts of data. Because of that many developers prefer to convert XML files to CSV format. XML to CSV conversion simplifies the data into a tabular format that is easy to manage and read. So, this article will demonstrate how to convert XML files to CSV in Java using REST API.

We will cover the following topics in this article:

Java XML to CSV Conversion REST API and SDK Installation#

GroupDocs.Conversion Cloud SDK for Java is a cloud-based document conversion solution that enables developers to convert various document formats to other formats programmatically in Java. It allows you to convert your documents, images, and email messages of any supported file format to any format with ease. This RESTful API can be integrated into Java applications to provide fast and reliable conversion capabilities.

You can either download the API JAR file or install API using Maven configurations. Add repository and dependency into your project’s pom.xml file.

Maven Repository:

 groupdocs-artifact-repository GroupDocs Artifact Repository https://repository.groupdocs.cloud/repo  

Maven Dependency:

 com.groupdocsgroupdocs-conversion-cloud 23.4 compile  

Now, sign up for a GroupDocs account and get your API key. Once you have the Client Id and Client Secret, add below code snippet in a Java-based application:

How to Convert XML File to CSV in Java using REST API#

Once the installation process is completed, you can jump to the code snippet that converts XML files to CSV format programmatically. Here’s how you can convert XML files to CSV in Java using GroupDocs.Conversion Cloud REST API:

Upload the File#

Firstly, upload the XML file to the cloud using the code snippet given below:

As a result, the uploaded XML file will be available in the files section of your dashboard on the cloud.

Convert XML to CSV File in Java#

In this section, we will see how to convert an XML file to CSV format programmatically in a Java application. You may follow the steps and the code snippet mentioned below:

• Firstly, import the required classes into your Java file.
• Secondly, create an instance of the ConvertApi class.
• Thirdly, create an instance of ConvertSettings class.
• Next, provide your cloud storage name.
• Now, set the source file path and the target format to “csv”.
• After that, set the output file path.
• Then, create the ConvertDocumentRequest class instance and pass the settings parameter.
• Finally, convert XML to CSV by calling the convert_document() method and passing the ConvertDocumentRequest parameter.

The following code snippet demonstrates how to convert XML to CSV file in Java using REST API:

You can see the output in the image below:

Download the Converted File#

The above code sample will save the converted CSV file in the cloud. You can download it using the following code sample:

Free Online XML to CSV Converter#

How to convert XML to CSV online for free? Please try the following free online XML to CSV converter. This converter is developed using the above-mentioned GroupDocs.Conversion Cloud REST API.

Conclusion#

We can end this blog post here. Hopefully, you have enjoyed the article and learned:

• how to change XML to CSV programmatically in Java;
• programmatically upload XML files and then download the converted CSV file from the cloud;
• and convert any XML file to CSV for free using a free online XML to CSV converter.

In addition, you can learn more about GroupDocs file format conversion API using the documentation, or by examples available on GitHub. We also provide an API Reference section that lets you visualize and interact with our APIs directly through the browser.

Finally, we keep writing new blog articles on different file formats and conversions using REST API. So, please get in touch for the latest updates.

Ask a question#

You can ask your queries about how to convert an XML document to a CSV file, via our forum.

FAQs#

How do I get started with GroupDocs.Conversion for Java SDK REST API?

You need to sign up for a GroupDocs account and download the GroupDocs.Conversion for Java SDK library, and add it to your Java project.

How can I convert an XML file to a CSV file in Java using REST API?

You need to upload the XML file to the cloud, then convert it to CSV format using the Java code provided. You will also need to download the converted file. The code snippet provided demonstrates the steps to convert an XML file to a CSV file using REST API.

How to convert XML to CSV on Windows?

Please visit the download link to download the XML to CSV offline converter for Windows. This free XML to CSV converter can be used to convert XML documents to CSV files on Windows quickly, with a single click.

How do I convert an XML to a CSV file online for free?

Please follow the step-by-step instructions to convert an XML file to CSV online for free:

• Open online XML to CSV converter.
• Now, click inside the file drop area to upload an XML file or drag & drop an XML file.
• Next, click on the Convert Now button. Online XML to CSV converter will transform XML into a CSV file.
• The download link of the output file will be available instantly after conversion.

See Also#

If you want to learn more about related topics, we recommend reading the articles listed below:

• Convert Word to Markdown and Markdown to Word in Python
• Convert PDF to Excel in Python using REST API
• How to Extract Pages From Word Documents in Python
• Convert Word Documents to PDF using REST API in Python
• Convert PDF to Editable Word Document with Python SDK
• How to Convert EXCEL to JSON and JSON to EXCEL in Python
• Convert MSG and EML files to PDF in Python
• Convert XML to CSV and CSV to XML in Python
• How to Convert CSV to JSON and JSON to CSV in Python
• Convert Word to PDF Programmatically in C#
• Convert HTML to PDF in Java using REST API

Источник

Java HTML / XML How to — Convert an XML file to CSV file

We would like to know how to convert an XML file to CSV file.

Answer

import java.io.File; /*w w w . j a v a2s.c o m*/ import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.transform.Result; import javax.xml.transform.Source; import javax.xml.transform.Transformer; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import javax.xml.transform.stream.StreamSource; import org.w3c.dom.Document; public class Main < public static void main(String args[]) throws Exception < File stylesheet = new File("style.xsl"); File xmlSource = new File("data.xml"); DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); DocumentBuilder builder = factory.newDocumentBuilder(); Document document = builder.parse(xmlSource); StreamSource stylesource = new StreamSource(stylesheet); Transformer transformer = TransformerFactory.newInstance() .newTransformer(stylesource); Source source = new DOMSource(document); Result outputTarget = new StreamResult(new File("/tmp/x.csv")); transformer.transform(source, outputTarget); > >

"1.0"?> "1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" > "text" omit-xml-declaration="yes" indent="no"/> "/"> Host_Name,IP_address,OS,Load_avg_1min,Load_avg_5min,Load_avg_15min for-each select="//Host"> "concat(Host,',',IP,',',OS,',',Load,',',Load,'
')"/> for-each> // www . j a v a2 s .co m  

Host_Name,IP_address,OS,Load_avg_1min,Load_avg_5min,Load_avg_15min srv001001,10.1.2.3,Windows1.3,2.5,1.2 srv001002,10.1.2.4,Linux1.4,2.5,1.2 srv001003,10.1.2.5,Linux3.3,1.6,1.8 srv001004,10.1.2.6,Linux2.3,4.5,4.2

java2s.com | © Demo Source and Support. All rights reserved.

Источник