java 打开scv 文件_JAVA读写CSV文件

最近工作需要，需要读写CSV文件的数据，简单封装了一下

依赖

读写CSV文件只需引用javacsv这个依赖就可以了

net.sourceforge.javacsv

javacsv

2.0

读文件

/**

* Read from CSV

*

* @param separator 分隔符

* @param filePath 文件路径

* @return

* */

public static List readFromCSV(Character separator, String filePath) {

CsvReader reader = null;

List result = new ArrayList<>();

try {

//如果生产文件乱码，windows下用gbk，linux用UTF-8

reader = new CsvReader(filePath, separator, Charset.forName("GBK"));

// 读取标题

reader.readHeaders();

// 逐条读取记录，直至读完

while (reader.readRecord()) {

//读取第一例

reader.get(0);

//读取指定名字的列

reader.get("");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (null != reader) {

reader.close();

}

}

return result;

}

因为甜大王比较喜欢将读取的一列封装为一个Object，同时为了工具更通用返回的结果类型是一个List

写文件

/**

* Write into CSV

*

* @param separator 分隔符

* @param filePath 文件路径

* @param strList 对应CSV中的一行记录

* */

public static void writeIntoCSV(Character separator, String filePath, List> strList) {

CsvWriter csvWriter = null;

try {

// 创建CSV写对象

csvWriter = new CsvWriter(filePath, separator, Charset.forName("GBK"));

// 写标题

//String[] headers = {"FileName","FileSize","FileMD5"};

//csvWriter.writeRecord(headers);

for (List list : strList) {

String[] writeLine = new String[list.size()];

list.toArray(writeLine);

csvWriter.writeRecord(writeLine);

}

csvWriter.close();

} catch (IOException e) {

e.printStackTrace();

} finally {

if (null != csvWriter) {

csvWriter.close();

}

}

}

完整代码

public class CSVTool {

/**

* Read from CSV

*

* @param separator 分隔符

* @param filePath 文件路径

* @return

* */

public static List readFromCSV(Character separator, String filePath) {

CsvReader reader = null;

List result = new ArrayList<>();

try {

//如果生产文件乱码，windows下用gbk，linux用UTF-8

reader = new CsvReader(filePath, separator, Charset.forName("GBK"));

// 读取标题

reader.readHeaders();

// 逐条读取记录，直至读完

while (reader.readRecord()) {

//读取第一例

reader.get(0);

//读取指定名字的列

reader.get("");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (null != reader) {

reader.close();

}

}

return result;

}

/**

* Write into CSV

*

* @param separator 分隔符

* @param filePath 文件路径

* @param strList 对应CSV中的一行记录

* */

public static void writeIntoCSV(Character separator, String filePath, List> strList) {

CsvWriter csvWriter = null;

try {

// 创建CSV写对象

csvWriter = new CsvWriter(filePath, separator, Charset.forName("GBK"));

// 写标题

//String[] headers = {"FileName","FileSize","FileMD5"};

//csvWriter.writeRecord(headers);

for (List list : strList) {

String[] writeLine = new String[list.size()];

list.toArray(writeLine);

csvWriter.writeRecord(writeLine);

}

csvWriter.close();

} catch (IOException e) {

e.printStackTrace();

} finally {

if (null != csvWriter) {

csvWriter.close();

}

}

}

}

附：[完整代码]()