java库学习之opencsv

java中读写csv文件的库

    com.opencsv
    opencsv
    4.5

http://opencsv.sourceforge.net/

public void test_write_csv() {
        String myPath ="data_"+System.currentTimeMillis() + ".csv";
        String str = "a,b,c,d,e,f,g,hn1,2,3,4,5,6,7,8";
        String[] split = str.split("n");
        List data = new ArrayList<>();
        for (int i = 0; i < split.length; i++) {
            data.add(split[i].split(","));
        }
        try (CSVWriter writer = new CSVWriter(Files.newBufferedWriter(Paths.get(myPath), StandardCharsets.UTF_8),
                CSVWriter.DEFAULT_SEPARATOR,
                CSVWriter.NO_QUOTE_CHARACTER,
                CSVWriter.NO_ESCAPE_CHARACTER,
                CSVWriter.DEFAULT_LINE_END)) {
            //写数据到文件
            writer.writeAll(data);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

public void test_read_csv() throws IOException {
        String myPath ="D:\projects\tmp\ume-plugins-REM-RNC\NONE\V1\plugins\cli\modules\rnccli\1656414764057.csv";
        CSVReader reader = new CSVReader(new FileReader(myPath));
        List list = reader.readAll();
        for (String[] item : list) {
            System.out.println(Arrays.asList(item));
        }

1. 以逗号为分隔符，数据中有逗号，会错位，解决方法，数据加上双引号便可区分