Javafascination: December 2012

Friday, December 14, 2012

CSV, comma separated values, files are commonly used to transport large amounts of tabular data between either companies or applications that are not directly connected. The files are easily editable using common spreadsheet applications like Microsoft Excel.

Fields are separated by commas.
Records are separated with system end of line characters, CRLF (ASCII 13 Dec or 0D Hex and ASCII 10 Dec or 0A Hex respectively) for Windows, LF for Unix, and CR for Mac.
For this application you need one jar file
That is : javacsv.jar

CSVReadExample.java


/**
 * File Name         :  CSVReadExample.java
 * Created By        :  Nagaraju V
 * Created Date      :  Aug 06, 2009
 * Purpose           :  Reading Data from CSV formated file
 */
package com.raj.csv;

import com.csvreader.CsvReader;

/**
 * @author nagarajuv
 *
 */
public class CSVReadExample {
 
 public static void main(String arg[]) throws Exception {
  CsvReader reader = new CsvReader("employees.csv");
  reader.readHeaders();
  System.out.println("EmpID \t EmpName \t Salary \t Age \t Experiance \t MobileNo");
  while (reader.readRecord()) {
   String EmpID = reader.get("EmpID");
   String EmpName = reader.get("EmpName");
   String Salary = reader.get("Salary");
   String Age = reader.get("Age");
   String Exp = reader.get("Exp");
   String MobileNo = reader.get("MobileNo");
   
   System.out.println(EmpID+"\t"+EmpName+"\t"+Salary+"\t"+Age+"\t"+Exp+"\t"+MobileNo);
  }
  reader.close();
 }
}