CSV is the initials of a comma-delimited file (Comma separated Values), a plain text format for storing data, often used in spreadsheets or database software. In a CSV file, the Data "column" is separated by commas, allowing the program to re-create the correct column structure for the data by reading the file and starting a new column each time a comma is encountered.
1, CSV file opened with text to display as:
1, John, male
2, Dick, male
3, Xiao Hong, female
2, CSV file opened in Excel display as:
First, the use of javacsv2.0 operation CSV file:
Package Com.iflytek.demo;
Import Java.io.FileOutputStream;
Import java.io.IOException;
Import Java.nio.charset.Charset;
Import java.util.ArrayList;
Import java.util.List;
Import Com.csvreader.CsvReader;
Import Com.csvreader.CsvWriter; /** * Use javacsv2.0 to do Import Export CSV file Tool class <br/> * * * * @author kpchen * */public class Csvutil {static char Separat
or = ', ';
public static void Main (string[] args) throws Exception {//test export String FilePath = "D:/test.csv";
list<string[]> dataList = new arraylist<string[]> ();
for (int i = 0; i < i++) {Datalist.add (new string[] {"0" + I, "xiaoming" + I, "Java" + i});
} exportcsv (DataList, FilePath);
Test import list<string[]> datas = ImportCSV (FilePath);
For (string[] strings:datas) {System.out.println (strings[0]); /** * Java Import CSV file * * @param filePath * Import path * @return * @throws Exception/Public STA Tic list<string[]> importcsv (String filePath) throws Exception {Csvreader reader = null;
list<string[]> dataList = new arraylist<string[]> ();
try {reader = new Csvreader (FilePath, separator, charset.forname ("GBK"));
Read the table header reader.readheaders ();
Read each record until you have read the while (Reader.readrecord ()) {Datalist.add (Reader.getrawrecord ()). Split (","));
Here are a few common methods//read a record System.out.println (Reader.getrawrecord ());
Reads the value of this record by column name System.out.println (reader.get (0));
System.out.println (Reader.get (1));
System.out.println (Reader.get (2));
System.out.println (Reader.get (3));
} catch (Exception e) {System.out.println ("Error reading CSV ..." + e);
Throw e;
finally {if (null!= reader) {reader.close ();
} return dataList;
/** * Java Export CVS file * * @param dataList * Data set * @param filePath * Export path * @return * @throws Exception */public static Boolean exportcsv (List<string[]> dataList, String filePath) throws Exception {
Boolean issuccess = false;
Csvwriter writer = null;
FileOutputStream out = null;
try {out = new FileOutputStream (FilePath, true);
writer = new Csvwriter (out, separator, charset.forname ("GBK"));
For (string[] strs:datalist) {Writer.writerecord (STRs);
} issuccess = true;
The catch (Exception e) {System.out.println ("Generate CSV error ..." + e);
Throw e;
finally {if (null!= writer) {writer.close ();
} if (null!= out) {try {out.close ();
catch (IOException e) {System.out.println ("Exportcsv close Exception:" + e);
Throw e;
}} return issuccess;
}
}
Second, the use of flow operation CSV file
Package Com.iflytek.demo;
Import Java.io.BufferedReader;
Import Java.io.BufferedWriter;
Import Java.io.File;
Import Java.io.FileOutputStream;
Import Java.io.FileReader;
Import java.io.IOException;
Import Java.io.OutputStreamWriter;
Import java.util.ArrayList;
Import java.util.List; public class CSVUtil2 {public static void main (string[] args) {//Test export//list<string> dataList = new Array
List<string> ();
Datalist.add ("1, John, Male");
Datalist.add ("2, Dick, male");
Datalist.add ("3, Little Red, female");
Boolean issuccess = Exportcsv (New File ("D:/test.csv"), dataList);
System.out.println (issuccess);
Test import list<string> dataList = ImportCSV (New File ("D:/test.csv"));
if (dataList!= null &&!datalist.isempty ()) {for (String data:datalist) {System.out.println (data); }}/** * Export * * @param file * CSV files (path + filename), the CSV file does not exist will automatically create * @param dataList * Data * @return */public static Boolean Exportcsv(File file, list<string> dataList)
{Boolean issucess = false;
FileOutputStream out = null;
OutputStreamWriter OSW = null;
BufferedWriter bw = NULL;
try {out = new FileOutputStream (file);
OSW = new OutputStreamWriter (out);
BW = new BufferedWriter (OSW); if (dataList!= null &&!datalist.isempty ()) {for (String data:datalist) {bw.append (data). Append ("\r\
n ");
} issucess = true;
catch (Exception e) {issucess = false;
finally {if (BW!= null) {try {bw.close ();
BW = NULL;
catch (IOException e) {e.printstacktrace ();
} if (OSW!= null) {try {osw.close ();
OSW = null;
catch (IOException e) {e.printstacktrace ();
} if (out!= null) {try {out.close ();
out = null;
catch (IOException e) {e.printstacktrace ();
}} return issucess; /** * Import * * @param file * CSV files (path + file) * @return */public static list<string> importcsv (file file) {list<string> dataList = new Arraylist<string>
;();
BufferedReader br = null;
try {br = new BufferedReader (new FileReader (file));
String line = "";
while (line = Br.readline ())!= null) {Datalist.add (line);
} catch (Exception e) {} finally {if (br!= null) {try {br.close ();
br = NULL;
catch (IOException e) {e.printstacktrace ();
}} return dataList;
}
}
Source: Http://pan.baidu.com/s/1nt1r7ap
Reference: http://write.blog.csdn.net/postedit/49755535