java 解析csv文件

 

1. 依赖引入

<dependency>
            <groupId>com.opencsv</groupId>
            <artifactId>opencsv</artifactId>
            <version>5.6</version>
        </dependency>

2.代码,在处理中文时需要考虑字符集的转换

import com.google.common.collect.Lists;
import com.opencsv.CSVReader;
import org.apache.commons.io.IOUtils;

import java.io.*;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.List;

public class CSVParserExample {
    public static void main(String[] args) {
        try {
            // 创建CSV读取对象
            String filePath = "D:\\your.csv";
            File file = new File(filePath);
            DataInputStream in = new DataInputStream(Files.newInputStream(file.toPath()));
            CSVReader csvReader = new CSVReader(new InputStreamReader(in,"gbk"));
            List<String[]> recordsList = csvReader.readAll();
            // 处理读取到的数据
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}