• Java
    • JAXB Tutorial
      • What is JAXB
      • JAXB Marshalling Example
      • JAXB UnMarshalling Example
  • Spring Tutorial
    • Spring Core Tutorial
    • Spring MVC Tutorial
      • Quick Start
        • Flow Diagram
        • Hello World Example
        • Form Handling Example
      • Handler Mapping
        • BeanNameUrlHandlerMapping
        • ControllerClassNameHandlerMapping
        • SimpleUrlHandlerMapping
      • Validation & Exception Handling
        • Validation+Annotations
        • Validation+ResourceBundle
        • @ExceptionHandler
        • @ControllerAdvice
        • Custom Exception Handling
      • Form Tag Library
        • Textbox Example
        • TextArea Example
        • Password Example
        • Dropdown Box Example
        • Checkboxes Example
        • Radiobuttons Example
        • HiddenValue Example
      • Misc
        • Change Config file name
    • Spring Boot Tutorial
  • Hibernate Tutorial
  • REST Tutorial
    • JAX-RS REST @PathParam Example
    • JAX-RS REST @QueryParam Example
    • JAX-RS REST @DefaultValue Example
    • JAX-RS REST @Context Example
    • JAX-RS REST @MatrixParam Example
    • JAX-RS REST @FormParam Example
    • JAX-RS REST @Produces Example
    • JAX-RS REST @Consumes Example
    • JAX-RS REST @Produces both XML and JSON Example
    • JAX-RS REST @Consumes both XML and JSON Example
  • Miscellaneous
    • JSON Parser
      • Read a JSON file
      • Write JSON object to File
      • Read / Write JSON using GSON
      • Java Object to JSON using JAXB
    • CSV Parser
      • Read / Write CSV file
      • Read/Parse/Write CSV File – OpenCSV
      • Export data into a CSV File
      • CsvToBean and BeanToCsv – OpenCSV

JavaInterviewPoint

Java Development Tutorials

How to Export data into a CSV File

January 18, 2016 by javainterviewpoint Leave a Comment

We already seen how to Parse a CSV file, in this example we will learn how to Write/Export data to CSV File using simple Java.

Employee.java

Employee class is a simple POJO to hold Employee details such as EmpId, FirstName, LastName, Salary.

package com.javainterviewpoint;

public class Employee 
{
    private int empId;
    private String firstName;
    private String lastName;
    private int salary;
    
    public Employee(int empId, String firstName, String lastName, int salary) {
        super();
        this.empId = empId;
        this.firstName = firstName;
        this.lastName = lastName;
        this.salary = salary;
    }
    
    public int getEmpId() {
        return empId;
    }
    public void setEmpId(int empId) {
        this.empId = empId;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public int getSalary() {
        return salary;
    }
    public void setSalary(int salary) {
        this.salary = salary;
    }

    @Override
    public String toString() {
        return "Employee [empId=" + empId + ", firstName=" + firstName
                + ", lastName=" + lastName + ", salary=" + salary + "]";
    }
}

Writing a CSV File

We will be using simple FileWriter here to export our Employee object to Employee.csv

package com.javainterviewpoint;

import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class WriteCSVFile 
{
	//Delimiters which has to be in the CSV file
	private static final String COMMA_DELIMITER = ",";
    private static final String LINE_SEPARATOR = "\n";
    
    //File header
    private static final String HEADER = "EmployeeID,FirstName,LastName,Salary";
    
    public static void main(String args[])
    {
    	//Creating Employee objects
    	Employee emp1 = new Employee(1,"FirstName1","LastName1",10000);
    	Employee emp2 = new Employee(2,"FirstName2","LastName2",20000);
    	Employee emp3 = new Employee(3,"FirstName3","LastName3",30000);
    	Employee emp4 = new Employee(4,"FirstName4","LastName4",40000);
    	Employee emp5 = new Employee(5,"FirstName5","LastName5",50000);
    	
    	//Add Employee objects to a list
    	List empList = new ArrayList();
    	empList.add(emp1);
    	empList.add(emp2);
    	empList.add(emp3);
    	empList.add(emp4);
    	empList.add(emp5);
    	
    	FileWriter fileWriter = null;
    	
    	try
    	{
    		fileWriter = new FileWriter("Employee.csv");
    		
    		//Adding the header
    		fileWriter.append(HEADER);
    		//New Line after the header
    		fileWriter.append(LINE_SEPARATOR);
    		
    		//Iterate the empList
    		Iterator it = empList.iterator();
    		while(it.hasNext())
    		{
    			Employee e = (Employee)it.next();
    			fileWriter.append(String.valueOf(e.getEmpId()));
    			fileWriter.append(COMMA_DELIMITER);
    			fileWriter.append(e.getFirstName());
    			fileWriter.append(COMMA_DELIMITER);
    			fileWriter.append(e.getLastName());
    			fileWriter.append(COMMA_DELIMITER);
    			fileWriter.append(String.valueOf(e.getSalary()));
    			fileWriter.append(LINE_SEPARATOR);
    		}
    		System.out.println("Write to CSV file Succeeded!!!");
    	}
    	catch(Exception ee)
    	{
    		ee.printStackTrace();
    	}
    	finally
    	{
    		try
    		{
    			fileWriter.close();
    		}
    		catch(IOException ie)
    		{
    			System.out.println("Error occured while closing the fileWriter");
    			ie.printStackTrace();
    		}
    	}
    }
}

Output : 

Employee.csv will be created

EmployeeID,FirstName,LastName,Salary
1,FirstName1,LastName1,10000
2,FirstName2,LastName2,20000
3,FirstName3,LastName3,30000
4,FirstName4,LastName4,40000
5,FirstName5,LastName5,50000

Other interesting articles which you may like …

  • How to Read/Parse/Write CSV File using OpenCSV
  • CsvToBean and BeanToCsv Example – Using OpenCSV
  • How to Read Excel File in Java using POI
  • How to Write Excel File in Java using POI
  • JAXB Tutorial – What is JAXB
  • JAXB Marshalling Example – Convert Java Object to XML in Java
  • JAXB UnMarshalling Example – Convert XML to Java Object
  • How to Convert Java Object to JSON using JAXB

Filed Under: Core Java, Java Tagged With: CSV, Export CSV, FileWriter, Write CSV

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Java Basics

  • JVM Architecture
  • Object in Java
  • Class in Java
  • How to Set Classpath for Java in Windows
  • Components of JDK
  • Decompiling a class file
  • Use of Class.forName in java
  • Use Class.forName in SQL JDBC

Oops Concepts

  • Inheritance in Java
  • Types of Inheritance in Java
  • Single Inheritance in Java
  • Multiple Inheritance in Java
  • Multilevel Inheritance in Java
  • Hierarchical Inheritance in Java
  • Hybrid Inheritance in Java
  • Polymorphism in Java – Method Overloading and Overriding
  • Types of Polymorphism in java
  • Method Overriding in Java
  • Can we Overload static methods in Java
  • Can we Override static methods in Java
  • Java Constructor Overloading
  • Java Method Overloading Example
  • Encapsulation in Java with Example
  • Constructor in Java
  • Constructor in an Interface?
  • Parameterized Constructor in Java
  • Constructor Chaining with example
  • What is the use of a Private Constructors in Java
  • Interface in Java
  • What is Marker Interface
  • Abstract Class in Java

Java Keywords

  • Java this keyword
  • Java super keyword
  • Final Keyword in Java
  • static Keyword in Java
  • Static Import
  • Transient Keyword

Miscellaneous

  • newInstance() method
  • How does Hashmap works internally in Java
  • Java Ternary operator
  • How System.out.println() really work?
  • Autoboxing and Unboxing Examples
  • Serialization and Deserialization in Java with Example
  • Generate SerialVersionUID in Java
  • How to make a class Immutable in Java
  • Differences betwen HashMap and Hashtable
  • Difference between Enumeration and Iterator ?
  • Difference between fail-fast and fail-safe Iterator
  • Difference Between Interface and Abstract Class in Java
  • Difference between equals() and ==
  • Sort Objects in a ArrayList using Java Comparable Interface
  • Sort Objects in a ArrayList using Java Comparator

Follow

  • Coding Utils

Useful Links

  • Spring 4.1.x Documentation
  • Spring 3.2.x Documentation
  • Spring 2.5.x Documentation
  • Java 6 API
  • Java 7 API
  • Java 8 API
  • Java EE 5 Tutorial
  • Java EE 6 Tutorial
  • Java EE 7 Tutorial
  • Maven Repository
  • Hibernate ORM

About JavaInterviewPoint

javainterviewpoint.com is a tech blog dedicated to all Java/J2EE developers and Web Developers. We publish useful tutorials on Java, J2EE and all latest frameworks.

All examples and tutorials posted here are very well tested in our development environment.

Connect with us on Facebook | Privacy Policy | Sitemap

Copyright ©2023 · Java Interview Point - All Rights Are Reserved ·