Posts

Showing posts from May, 2013

How to convert a Java Object List into csv.

Wrote a general method to convert a List into a CSV file. package com.biplav.utils import java.lang.reflect.Field; import java.lang.reflect.Modifier; import java.util.ArrayList; import java.util.List; import org.apache.log4j.Logger; public class ObjectListToCSV { private static final Logger logger = Logger.getLogger(ObjectListToCSV.class); private static final String CSV_SEPARATOR = ","; public static String convertListToCSV(List objectList) { if(objectList.size() < 1) { logger.info("No data in the list to convert to CDR!"); return ""; } String csv = ""; T t = objectList.get(0); Field[] declaredFields = t.getClass().getDeclaredFields(); ArrayList useableFields = getUseableFields(declaredFields); csv = getCSVHeader(csv, useableFields,null); csv=csv.concat("\n"); for(T object : objectList) { csv = addObjectValue(csv, useableFields, object); csv=csv.concat("\n"); }