Thursday 20 September 2012

Reading and Writing CSV Formated Data

Reading/Writing an excel document like you requested, you can use the CSV format


import java.io.BufferedReader;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Scanner;
public class CsvWriter {
 
public static void main(String args[]) throws IOException {

 
String fileName = "test.xls";

 
PrintWriter out = new PrintWriter(new FileWriter(fileName));
  out
.println("a,b,c,d");
  out
.println("e,f,g,h");
  out
.println("i,j,k,l");
  out
.close();

 
BufferedReader in = new BufferedReader(new FileReader(fileName));
 
String line = null;
 
while ((line = in.readLine()) != null) {

   
Scanner scanner = new Scanner(line);
   
String sep = "";
   
while (scanner.hasNext()) {
   
System.out.println(sep + scanner.next());
    sep
= ",";
   
}
 
}
  in
.close();
 
}
}

2 comments:

  1. nice Post
    Yaaron Studios is one of the rapidly growing editing studios in Hyderabad. We are the best Video Editing services in Hyderabad. We provides best graphic works like logo reveals, corporate presentation Etc. And also we gives the best Outdoor/Indoor shoots and Ad Making services.
    Best video editing services in Hyderabad,ameerpet
    Best Graphic Designing services in Hyderabad,ameerpet­
    Best Ad Making services in Hyderabad,ameerpet­

    ReplyDelete
  2. Nice blog, Keep sharing such informative content to upskill the students knowledge. Apply for best industry expert training for solidworks online course

    ReplyDelete