apache common之CSV文件操作

86 阅读 0 评论 57 点赞

我是靠谱客的博主炙热冥王星，最近开发中收集的这篇文章主要介绍apache common之CSV文件操作，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

依赖jar：

<dependency>
	<groupId>org.apache.commons</groupId>
	<artifactId>commons-csv</artifactId>
	<version>1.0</version>
</dependency>

写操作：

List<String[]> data = new ArrayList<String[]>();
data.add(new String[] { "A", "B", "C" });
data.add(new String[] { "1", "2", "3" });
data.add(new String[] { "A1", "B2", "C3" });
FileWriter fw = new FileWriter(new File("c:/linkrmb.com.csv"));
final CSVPrinter printer = CSVFormat.EXCEL.print(fw);
printer.printRecords(data);
printer.flush();
printer.close();

读操作：

String path = "c:/linkrmb.com.csv";
InputStream inputStream = new FileInputStream(path);
InputStreamReader isr = new InputStreamReader(inputStream);
Iterable<CSVRecord> records = CSVFormat.EXCEL.parse(isr);
for (CSVRecord record : records) {
	for (String string : record) {
		System.out.print(string);
		System.out.print("-");

	}
	System.out.println();
	System.out.println("*****************");
}