BE THE CODER > CSV > OPEN CSV Examples > CSV to Bean using Header to Column Name Translate Mapping Strategy

opencsv is a free and open source library for reading and writing CSV files in Java. We need to have opencsv-2.3.jar or later versions in classpath. The following example shows populating a java bean from CSV using opencsv. This strategy is useful when parsing CSVs having header but no matching property names in java bean. We need to specify an explicit mapping between the header name and corresponding java bean property name using setColumnMapping method.

File Name :	com/bethecoder/tutorials/open_csv/tests/CSV2BeanColumnNameTranslate.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.open_csv.tests;



import java.io.StringReader;

import java.util.HashMap;

import java.util.List;

import java.util.Map;



import au.com.bytecode.opencsv.bean.CsvToBean;

import au.com.bytecode.opencsv.bean.HeaderColumnNameTranslateMappingStrategy;



import com.bethecoder.tutorials.open_csv.common.Student;



public class CSV2BeanColumnNameTranslate {



  /**

   * @param args

   */

  public static void main(String[] args) {



    //Make sure no spaces in header

    String CSV = 

      "FullName,AGE,pursuit\n" +

      "Sriram,2,Chess\n" +

      "Sudhakar,29,Painting";

    

    CsvToBean<Student> bean = new CsvToBean<Student>();

    

    //Define strategy

    //Header name to bean property name mapping

    Map<String, String> columnMapping = new HashMap<String, String>();

    columnMapping.put("FullName", "name");

    columnMapping.put("AGE", "age");

    columnMapping.put("pursuit", "hobby");

    

    HeaderColumnNameTranslateMappingStrategy<Student> strategy = 

        new HeaderColumnNameTranslateMappingStrategy<Student>();

    strategy.setType(Student.class);

    strategy.setColumnMapping(columnMapping);

    

    //Parse the CSV

    List<Student> students = bean.parse(strategy, new StringReader(CSV));

        System.out.println(students);

  }

}

File Name :

com/bethecoder/tutorials/open_csv/common/Student.java


package com.bethecoder.tutorials.open_csv.common;



public class Student {



  private String name;

  private int age;

  private String hobby;

  

  public Student() {

  }



  public Student(String name, int age, String hobby) {

    super();

    this.name = name;

    this.age = age;

    this.hobby = hobby;

  }

  

  public String getName() {

    return name;

  }

  public void setName(String name) {

    this.name = name;

  }

  public int getAge() {

    return age;

  }

  public void setAge(int age) {

    this.age = age;

  }

  public String getHobby() {

    return hobby;

  }

  public void setHobby(String hobby) {

    this.hobby = hobby;

  }

  

  public String toString() {

    return "Student[name = " + name + ", age = " + age + ", hobby = " + hobby + "]";

  }

}