java csv 单元格格式_Java读写CSV格式的文件

读取CSV文件

/**

* 读取 CSV 文件

*

* @return

*/

public static LinkedList readCSV(String path) {

LinkedList list = new LinkedList<>();

BufferedReader reader = null;

try {

FileInputStream fis = new FileInputStream(path);

InputStreamReader isr = new InputStreamReader(fis, "GBK");

reader = new BufferedReader(isr);

String line;

while ((line = reader.readLine()) != null) {

String[] rows = line.split(",");

CsvData info = new CsvData();

info.setColumn1(rows.length > 0 ? rows[0] : null);

info.setColumn2(rows.length > 1 ? rows[1] : null);

info.setColumn3(rows.length > 2 ? rows[2] : null);

info.setColumn4(rows.length > 3 ? rows[3] : null);

info.setColumn5(rows.length > 4 ? rows[4] : null);

list.add(info);

}

} catch (IOException e) {

e.printStackTrace();

} finally {

if (reader != null) {

try {

reader.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

if (!list.isEmpty()) {

// 移除 CSV 首行标题

list.remove(0);

}

return list;

}

CsvData.java

public class CsvData {

private String column1;

private String column2;

private String column3;

private String column4;

private String column5;

// 生成 Getter 和 Setter

}

写入CSV文件

/**

* 写入 CSV 文件

*

* @return

*/

public static void writeCsv(List dataList, String filePath) {

CsvData header = new CsvData();

header.setColumn1("列1");

header.setColumn2("列2");

header.setColumn3("列3");

header.setColumn4("列4");

header.setColumn5("列5");

dataList.add(0, header);

try {

FileOutputStream fos = new FileOutputStream(new File(filePath));

OutputStreamWriter osw = new OutputStreamWriter(fos, "GBK");

BufferedWriter bw = new BufferedWriter(osw);

for (CsvData data : dataList) {

String line = data.getColumn1() + ","

+ data.getColumn2() + ","

+ data.getColumn3() + ","

+ data.getColumn4() + ","

+ data.getColumn5();

bw.write(line + "\t\n");

}

bw.close();

osw.close();

fos.close();

} catch (Exception e) {

e.printStackTrace();

}

}