csv调研

supercsv:下面这个不能用
试用了中文的几个1.5版的代码，都是乱码，这个工程08年的，很久没更新了
对应的jar,SuperCSV-1.52.jar

public class OperateCsv {

	/**
	 * 读取csv文件(不带头部)
	 * 
	 * @param file File
	 * @return csv文件组装成list
	 * @throws IOException
	 */
	public List<String[]> getContentFromFile(File file) throws IOException {
		List<String[]> content = new ArrayList<String[]>();
		;
		CsvListReader reader = new CsvListReader(new FileReader

		(file), CsvPreference.EXCEL_PREFERENCE);
		reader.getCSVHeader(true);// 去除头部字段声明
		List<String> line = new ArrayList<String>();
		while ((line = reader.read()) != null) {
			content.add(line.toArray(new String[] {}));
		}
		return content;
	}

	/**
	 * 读取csv文件(带头部)
	 * 
	 * @param file File
	 * @return csv文件组装成list
	 * @throws IOException
	 */
	public List<String[]> getDetailFromFile(File file) throws IOException {
		List<String[]> content = new ArrayList<String[]>();
		;
		CsvListReader reader = new CsvListReader(new FileReader

		(file), CsvPreference.EXCEL_PREFERENCE);
		String[] header = reader.getCSVHeader(true);
		content.add(header);
		List<String> line = new ArrayList<String>();
		while ((line = reader.read()) != null) {
			content.add(line.toArray(new String[] {}));
		}
		return content;
	}

	/**
	 * 读取csv文件的头部
	 * 
	 * @param file File
	 * @return csv文件的头部
	 * @throws IOException
	 */
	public String[] getHeaderFromFile(File file) throws IOException {
		CsvListReader reader = new CsvListReader(new FileReader

		(file), CsvPreference.EXCEL_PREFERENCE);
		return reader.getCSVHeader(true);
	}

	/**
	 * 写入csv文件
	 * 
	 * @param file File
	 * @param header 头部
	 * @param content 内容
	 * @throws IOException
	 */
	public void writeToCsv(File file, String[] header, List<String[]> content) throws

	IOException {
		CsvListWriter writer = new CsvListWriter(new FileWriter(file),

		CsvPreference.EXCEL_PREFERENCE);
		writer.writeHeader(header);
		for (String[] str : content) {
			writer.write(str);
		}
		writer.close();
	}

	/**
	 * 写入csv文件
	 * 
	 * @param file File
	 * @param content 内容
	 * @throws IOException
	 */
	public void writeContentToCsv(File file, List<String[]> content) throws IOException {
		CsvListWriter writer = new CsvListWriter(new FileWriter(file),

		CsvPreference.EXCEL_PREFERENCE);
		for (String[] str : content) {
			writer.write(str);
		}
		writer.close();
	}

	/**
	 * 写入csv文件(头部)
	 * 
	 * @param file File
	 * @param content 内容
	 * @throws IOException
	 */
	public void writeHeaderToCsv(File file, String[] header) throws IOException {
		CsvListWriter writer = new CsvListWriter(new FileWriter(file),

		CsvPreference.EXCEL_PREFERENCE);
		writer.writeHeader(header);
		writer.close();
	}

	public static void main(String[] args) throws IOException {
		OperateCsv operateCsv = new OperateCsv();
		File file = new File("D://a.csv");
		List<String[]> content = operateCsv.getDetailFromFile(file);
		String[] header = operateCsv.getHeaderFromFile(file);
		for (String[] str : content) {
			for (int i = 0; i < str.length; i++) {

				System.out.println(str[i] + "  " + str[i + 1] + "  " + str[i + 2] + "  " + str[i + 3]);
				i = i + 4;

				// System.out.println(str[i]);

			}
			File file1 = new File("D:/2.csv");
			operateCsv.writeToCsv(file1, header, content);
			operateCsv.writeHeaderToCsv(file1, header);
			operateCsv.writeContentToCsv(file1, content);
		}
	}
}

CsvReader:而且这个居然做c#不做java了，卖钱去了
对应的jar，javacsv.jar
com.csvreader.CsvReader
debug中可以看到有key-value的字段，但是从方法中貌似拿不到

package com.csv.javacsv;

import java.io.IOException;
import java.nio.charset.Charset;
import java.util.ArrayList;

import com.csvreader.CsvReader;
import com.csvreader.CsvWriter;

public class JavaCsvTest {

	public static void main(String[] args) {
		JavaCsvTest test = new JavaCsvTest();
		test.readeCsv();
	}

	public void t1() throws Exception {
		String csvFilePath = "d:/test.csv";
		CsvReader reader = new CsvReader(csvFilePath, ',', Charset.forName("GBK")); // 一般用这编码读就可以了
	}

	/**
	 * 读取CSV文件
	 */
	public void readeCsv() {
		try {

			ArrayList<String[]> csvList = new ArrayList<String[]>(); // 用来保存数据
			String csvFilePath = "d:/test.csv";
			CsvReader reader = new CsvReader(csvFilePath, ',', Charset.forName("GBK")); // 一般用这编码读就可以了

			reader.readHeaders(); // 跳过表头 如果需要表头的话，不要写这句。

			while (reader.readRecord()) { // 逐行读入除表头的数据
				csvList.add(reader.getValues());
			}
			reader.getHeaders();

			reader.close();

			for (int row = 0; row < csvList.size(); row++) {
				for (int column = 0; column < 5; column++) {
					String cell = csvList.get(row)[column]; // 取得第row行第0列的数据
					System.out.println(cell);
				}
			}
		}
		catch (Exception ex) {
			System.out.println(ex);
		}
	}

	/**
	 * 写入CSV文件
	 */
	public void writeCsv() {
		try {

			String csvFilePath = "c:/test.csv";
			CsvWriter wr = new CsvWriter(csvFilePath, ',', Charset.forName("SJIS"));
			String[] contents = { "aaaaa", "bbbbb", "cccccc", "ddddddddd" };
			wr.writeRecord(contents);
			wr.close();
		}
		catch (IOException e) {
			e.printStackTrace();
		}
	}
}

opencsv
http://sourceforge.net/projects/opencsv/
http://chengyu2099.iteye.com/blog/1575198


Java CSV Library，
http://sourceforge.net/projects/javacsv/?source=recommended

评论

1 楼 idealab 2015-05-17  

博主说的OpenCSV, JavaCSV, SuperCSV都用过，目前在项目中使用uniVocity-parsers,他在性能和扩展性方面都更优一些，并且API简洁灵活。

具体的代码使用，可以参考如下代码：

public static void main(String[] args) throws IOException {
        /**
         * ---------------------------------------------
         *  Read CSV rows into list of beans you defined
         * ---------------------------------------------
         */

        // 1st, config the CSV reader with line separator
        CsvParserSettings settings = new CsvParserSettings();
        settings.getFormat().setLineSeparator("\n");

        // 2nd, config the CSV reader with row processor attaching the bean definition
        BeanListProcessor<Employee> rowProcessor = new BeanListProcessor<Employee>(Employee.class);
        settings.setRowProcessor(rowProcessor);

        // 3rd, creates a CSV parser with the configs
        CsvParser parser = new CsvParser(settings);

        // 4th, parse all rows from the CSF file into the list of beans you defined
        parser.parse(new FileReader("/examples/employees.csv"));
        List<Employee> resolvedBeans = rowProcessor.getBeans();

        // 5th, Store, Delete duplicates, Re-arrange the words in specific order
        // ......

        // 6th, Write the listed of processed employee beans out to a CSV file.
        CsvWriterSettings writerSettings = new CsvWriterSettings();

        // 6.1 Creates a BeanWriterProcessor that handles annotated fields in the Employee class.
        writerSettings.setRowWriterProcessor(new BeanWriterProcessor<Employee>(Employee.class));

        // 6.2 persistent the employee beans to a CSV file.
        CsvWriter writer = new CsvWriter(new FileWriter("/examples/processed_employees.csv"), writerSettings);
        writer.processRecords(resolvedBeans);
        writer.writeRows(new ArrayList<List<Object>>());
    }

上述代码通过简单的几行代码就可以将CSV文件读取为Java Bean列表，推荐使用。