概览

1. 什么叫做CSV

Comma-Separated Value （[卡门 赛婆乱提的]逗号分隔）（CSV），因分隔符没有严格的要求，可以使用逗号，也可以使用其他字符（如制表符\t，分号等），所以CSV也被称为逗号分隔或者其他字符分隔值。csv文件是使用纯文本来存储表格数据（只能存储文本，不能存储二进制）。

OpenCSV

  1. package com.mkyong.io.csv.opencsv;
  3. import com.opencsv.CSVReader;
  4. import com.opencsv.exceptions.CsvException;
  6. import java.io.FileReader;
  7. import java.io.IOException;
  8. import java.util.Arrays;
  9. import java.util.List;
  11. public class OpenCsvExample {
  13.     public static void main(String[] args) throws IOException, CsvException {
  15.         String fileName = "c:\\test\\csv\\country.csv";
  16.         try (CSVReader reader = new CSVReader(new FileReader(fileName))) {
  17.             List<String[]> r = reader.readAll();
  18.             r.forEach(x -> System.out.println(Arrays.toString(x)));
  19.         }
  21.     }
  23. }
  1.  List<String[]> collect =
  2.           Files.lines(Paths.get("c:\\test\\csv\\country.csv"))
  3.                 .map(line -> line.split(","))
  4.                 .collect(Collectors.toList());
  1. // Java code to illustrate reading a
  2. // all data at once
  3. public static void readAllDataAtOnce(String file)
  4. {
  5.     try {
  6.         // Create an object of file reader
  7.         // class with CSV file as a parameter.
  8.         FileReader filereader = new FileReader(file);
  10.         // create csvReader object and skip first Line
  11.         CSVReader csvReader = new CSVReaderBuilder(filereader)
  12.                                 .withSkipLines(1)
  13.                                 .build();
  14.         List<String[]> allData = csvReader.readAll();
  16.         // print Data
  17.         for (String[] row : allData) {
  18.             for (String cell : row) {
  19.                 System.out.print(cell + "\t");
  20.             }
  21.             System.out.println();
  22.         }
  23.     }
  24.     catch (Exception e) {
  25.         e.printStackTrace();
  26.     }
  27. }
  1. // Java code to illustrate
  2. // Reading CSV File with different separator
  3. public static void readDataFromCustomSeparator(String file)
  4. {
  5.     try {
  6.         // Create an object of file reader class with CSV file as a parameter.
  7.         FileReader filereader = new FileReader(file);
  9.         // create csvParser object with
  10.         // custom separator semi-colon
  11.         CSVParser parser = new CSVParserBuilder().withSeparator(';').build();
  13.         // create csvReader object with parameter
  14.         // filereader and parser
  15.         CSVReader csvReader = new CSVReaderBuilder(filereader)
  16.                                 .withCSVParser(parser)
  17.                                 .build();
  19.         // Read all data at once
  20.         List<String[]> allData = csvReader.readAll();
  22.         // Print Data.
  23.         for (String[] row : allData) {
  24.             for (String cell : row) {
  25.                 System.out.print(cell + "\t");
  26.             }
  27.             System.out.println();
  28.         }
  29.     }
  30.     catch (Exception e) {
  31.         e.printStackTrace();
  32.     }
  33. }

每次读一行

  1. // Java program to illustrate reading
  2. // two CSV files
  3. // with different separators
  5. import java.io.FileReader;
  6. import java.util.List;
  7. import com.opencsv.*;
  9. public class ReadCSVData {
  10.     private static final String CSV_FILE_PATH
  11.         = "D:\\EclipseWorkSpace\\CSVOperations\\results.csv";
  12.     private static final String CSV_FILE_CUSTOM_SEPARATOR
  13.         = "D:\\EclipseWorkSpace\\CSVOperations\\results_semicolon_Separator.csv";
  15.     public static void main(String[] args)
  16.     {
  18.         System.out.println("Read Data Line by Line With Header \n");
  19.         readDataLineByLine(CSV_FILE_PATH);
  20.         System.out.println("_______________________________________________");
  22.         System.out.println("Read All Data at Once and Hide the Header also \n");
  23.         readAllDataAtOnce(CSV_FILE_PATH);
  24.         System.out.println("_______________________________________________");
  26.         System.out.println("Custom Separator here semi-colon\n");
  27.         readDataFromCustomSeparator(CSV_FILE_CUSTOM_SEPARATOR);
  28.         System.out.println("_______________________________________________");
  29.     }
  31.     public static void readDataLineByLine(String file)
  32.     {
  34.         try {
  36.             // Create an object of filereader class
  37.             // with CSV file as a parameter.
  38.             FileReader filereader = new FileReader(file);
  40.             // create csvReader object passing
  41.             // filereader as parameter
  42.             CSVReader csvReader = new CSVReader(filereader);
  43.             String[] nextRecord;
  45.             // we are going to read data line by line
  46.             while ((nextRecord = csvReader.readNext()) != null) {
  47.                 for (String cell : nextRecord) {
  48.                     System.out.print(cell + "\t");
  49.                 }
  50.                 System.out.println();
  51.             }
  52.         }
  53.         catch (Exception e) {
  54.             e.printStackTrace();
  55.         }
  56.     }
  58.     public static void readAllDataAtOnce(String file)
  59.     {
  60.         try {
  62.             // Create an object of filereader class
  63.             // with CSV file as a parameter.
  64.             FileReader filereader = new FileReader(file);
  66.             // create csvReader object
  67.             // and skip first Line
  68.             CSVReader csvReader = new CSVReaderBuilder(filereader)
  69.                                     .withSkipLines(1)
  70.                                     .build();
  71.             List<String[]> allData = csvReader.readAll();
  73.             // print Data
  74.             for (String[] row : allData) {
  75.                 for (String cell : row) {
  76.                     System.out.print(cell + "\t");
  77.                 }
  78.                 System.out.println();
  79.             }
  80.         }
  81.         catch (Exception e) {
  82.             e.printStackTrace();
  83.         }
  84.     }
  86.     public static void readDataFromCustomSeparator(String file)
  87.     {
  88.         try {
  89.             // Create object of filereader
  90.             // class with csv file as parameter.
  91.             FileReader filereader = new FileReader(file);
  93.             // create csvParser object with
  94.             // custom separator semi-colon
  95.             CSVParser parser = new CSVParserBuilder().withSeparator(';').build();
  97.             // create csvReader object with
  98.             // parameter filereader and parser
  99.             CSVReader csvReader = new CSVReaderBuilder(filereader)
  100.                                     .withCSVParser(parser)
  101.                                     .build();
  103.             // Read all data at once
  104.             List<String[]> allData = csvReader.readAll();
  106.             // print Data
  107.             for (String[] row : allData) {
  108.                 for (String cell : row) {
  109.                     System.out.print(cell + "\t");
  110.                 }
  111.                 System.out.println();
  112.             }
  113.         }
  114.         catch (Exception e) {
  115.             e.printStackTrace();
  116.         }
  117.     }
  118. }

pom.xml

  1. <!-- csv文件解析依赖 -->
  2. <dependency>
  3.     <groupId>com.opencsv</groupId>
  4.     <artifactId>opencsv</artifactId>
  5.     <version>5.4</version>
  6. </dependency>

手动解析CSV文件

  1. //    析csv文件并转成bean（方法一）
  2. public static List<CsvFile> getCsvDataMethod1(MultipartFile file) {
  3.     ArrayList<CsvFile> csvFileList = new ArrayList<>();
  5.     InputStreamReader in = null;
  6.     String s = null;
  7.     try {
  8.         in = new InputStreamReader(file.getInputStream(), "utf-8");
  9.         BufferedReader bufferedReader = new BufferedReader(in);
  10.         String line = null;
  11.         while ((line = bufferedReader.readLine()) != null) {
  12.             String[] split = line.split(",");
  13.             CsvFile csvFile = new CsvFile();
  14.             csvFile.setName(splitResult(split[0]));
  15.             csvFile.setTitle(splitResult(split[1]));
  16.             csvFile.setNumber(splitResult(split[2]));
  17.             csvFile.setType(splitResult(split[3]));
  18.             csvFile.setPersonnel(splitResult(split[4]));
  19.             csvFile.setTime(splitResult(split[5]));
  20.             csvFileList.add(csvFile);
  21.         }
  22.     } catch (IOException e) {
  23.         e.printStackTrace();
  24.     }
  25.     return csvFileList;
  26.     }

去重引号“”

  1. private static String splitResult(String once) {
  2.         String result = "";
  3.         for (int i = 0; i < once.length(); i++) {
  4.             if (once.charAt(i) != '"') {
  5.                 result += once.charAt(i);
  6.             }
  7.         }
  8.         return result;
  9.     }

openCSV解析CSV文件

  1. /**
  2.      * 解析csv文件并转成bean（方法二）
  3.      *
  4.      * @param file csv文件
  5.      * @return 数组
  6.      */
  7.     public static List<String[]> getCsvDataMethod2(MultipartFile file) {
  9.         List<String[]> list = new ArrayList<String[]>();
  10.         int i = 0;
  11.         try {
  12.             CSVReader csvReader = new CSVReaderBuilder(
  13.                     new BufferedReader(
  14.                             new InputStreamReader(file.getInputStream(), "utf-8"))).build();
  15.             Iterator<String[]> iterator = csvReader.iterator();
  16.             while (iterator.hasNext()) {
  17.                 String[] next = iterator.next();
  18.                 //去除第一行的表头，从第二行开始
  19.                 if (i >= 1) {
  20.                     list.add(next);
  21.                 }
  22.                 i++;
  23.             }
  24.             return list;
  25.         } catch (Exception e) {
  26.             System.out.println("CSV文件读取异常");
  27.             return list;
  28.         }
  29.     }

openCSV解析CSV文件(结果为实体类)

工具类

  1. /**
  2.      * 解析csv文件并转成bean（方法三）
  3.      *
  4.      * @param file  csv文件
  5.      * @param clazz 类
  6.      * @param <T>   泛型
  7.      * @return 泛型bean集合
  8.      */
  9.     public static <T> List<T> getCsvDataMethod3(MultipartFile file, Class<T> clazz) {
  10.         InputStreamReader in = null;
  11.         CsvToBean<T> csvToBean = null;
  12.         try {
  13.             in = new InputStreamReader(file.getInputStream(), "utf-8");
  14.             HeaderColumnNameMappingStrategy<T> strategy = new HeaderColumnNameMappingStrategy<>();
  15.             strategy.setType(clazz);
  16.             csvToBean = new CsvToBeanBuilder<T>(in).withMappingStrategy(strategy).build();
  17.         } catch (Exception e) {
  18.             logger.error("数据转化失败");
  19.             return null;
  20.         }
  21.         return csvToBean.parse();
  22.     }

实体类

  1. import com.opencsv.bean.CsvBindByName;
  2. import lombok.Data;
  4. @Data
  5. public class CsvFile {
  7.     @CsvBindByName(column = "name")
  8.     private String name;
  10.     @CsvBindByName(column = "title")
  11.     private String title;
  13.     @CsvBindByName(column = "number")
  14.     private String number;
  16.     @CsvBindByName(column = "type")
  17.     private String type;
  19.     @CsvBindByName(column = "personnel")
  20.     private String personnel;
  22.     @CsvBindByName(column = "time")
  23.     private String time;
  24. }

整理完成的CsvUtils

  1. import com.lydms.testopencsv.domain.CsvFile;
  2. import com.opencsv.CSVReader;
  3. import com.opencsv.CSVReaderBuilder;
  4. import com.opencsv.bean.CsvToBean;
  5. import com.opencsv.bean.CsvToBeanBuilder;
  6. import com.opencsv.bean.HeaderColumnNameMappingStrategy;
  7. import org.apache.logging.log4j.LogManager;
  8. import org.apache.logging.log4j.Logger;
  9. import org.springframework.web.multipart.MultipartFile;
  11. import java.io.BufferedReader;
  12. import java.io.IOException;
  13. import java.io.InputStreamReader;
  14. import java.util.ArrayList;
  15. import java.util.Iterator;
  16. import java.util.List;
  19. public class CsvUtils {
  20.     private static final Logger logger = LogManager.getLogger(CsvUtils.class);
  23.     /**
  24.      * 解析csv文件并转成bean（方法二）
  25.      *
  26.      * @param file csv文件
  27.      * @return 数组
  28.      */
  29.     public static List<String[]> getCsvDataMethod2(MultipartFile file) {
  31.         List<String[]> list = new ArrayList<String[]>();
  32.         int i = 0;
  33.         try {
  34.             CSVReader csvReader = new CSVReaderBuilder(
  35.                     new BufferedReader(
  36.                             new InputStreamReader(file.getInputStream(), "utf-8"))).build();
  37.             Iterator<String[]> iterator = csvReader.iterator();
  38.             while (iterator.hasNext()) {
  39.                 String[] next = iterator.next();
  40.                 //去除第一行的表头，从第二行开始
  41.                 if (i >= 1) {
  42.                     list.add(next);
  43.                 }
  44.                 i++;
  45.             }
  46.             return list;
  47.         } catch (Exception e) {
  48.             System.out.println("CSV文件读取异常");
  49.             return list;
  50.         }
  51.     }
  54.     /**
  55.      * 解析csv文件并转成bean（方法三）
  56.      *
  57.      * @param file  csv文件
  58.      * @param clazz 类
  59.      * @param <T>   泛型
  60.      * @return 泛型bean集合
  61.      */
  62.     public static <T> List<T> getCsvDataMethod3(MultipartFile file, Class<T> clazz) {
  63.         InputStreamReader in = null;
  64.         CsvToBean<T> csvToBean = null;
  65.         try {
  66.             in = new InputStreamReader(file.getInputStream(), "utf-8");
  67.             HeaderColumnNameMappingStrategy<T> strategy = new HeaderColumnNameMappingStrategy<>();
  68.             strategy.setType(clazz);
  69.             csvToBean = new CsvToBeanBuilder<T>(in).withMappingStrategy(strategy).build();
  70.         } catch (Exception e) {
  71.             logger.error("数据转化失败");
  72.             return null;
  73.         }
  74.         return csvToBean.parse();
  75.     }
  78.     /**
  79.      * 解析csv文件并转成bean（方法一）
  80.      *
  81.      * @param file
  82.      * @return
  83.      */
  84.     public static List<CsvFile> getCsvDataMethod1(MultipartFile file) {
  85.         ArrayList<CsvFile> csvFileList = new ArrayList<>();
  87.         InputStreamReader in = null;
  88.         String s = null;
  89.         try {
  90.             in = new InputStreamReader(file.getInputStream(), "utf-8");
  91.             BufferedReader bufferedReader = new BufferedReader(in);
  92.             String line = null;
  93.             while ((line = bufferedReader.readLine()) != null) {
  94.                 String[] split = line.split(",");
  95.                 CsvFile csvFile = new CsvFile();
  96.                 csvFile.setName(splitResult(split[0]));
  97.                 csvFile.setTitle(splitResult(split[1]));
  98.                 csvFile.setNumber(splitResult(split[2]));
  99.                 csvFile.setType(splitResult(split[3]));
  100.                 csvFile.setPersonnel(splitResult(split[4]));
  101.                 csvFile.setTime(splitResult(split[5]));
  102.                 csvFileList.add(csvFile);
  103.             }
  104.         } catch (IOException e) {
  105.             e.printStackTrace();
  106.         }
  107.         return csvFileList;
  108.     }
  110.     private static String splitResult(String once) {
  111.         String result = "";
  112.         for (int i = 0; i < once.length(); i++) {
  113.             if (once.charAt(i) != '"') {
  114.                 result += once.charAt(i);
  115.             }
  116.         }
  117.         return result;
  118.     }
  119. }

根据java对象生成csv文件

readCsv

  1. public void readCsv(String finalPath) {
  2.     try {
  3.         Reader reader = new InputStreamReader(new FileInputStream(finalPath), StandardCharsets.UTF_8);
  4.         CSVReader csvReader = new CSVReaderBuilder(reader).build();
  6.         // 列名的映射
  7.         HeaderColumnNameTranslateMappingStrategy<Person> strategy =
  8.             new HeaderColumnNameTranslateMappingStrategy<>();
  9.         strategy.setType(Person.class);
  10.         Map<String, String> columnMapping = new HashMap<>();
  11.         columnMapping.put("编号", "id");
  12.         columnMapping.put("姓名", "name");
  13.         columnMapping.put("年龄", "age");
  14.         strategy.setColumnMapping(columnMapping);
  16.         CsvToBean<Person> csvToBean = new CsvToBeanBuilder(csvReader)
  17.             .withSeparator(CSVWriter.DEFAULT_SEPARATOR)
  18.             .withQuoteChar(CSVWriter.NO_QUOTE_CHARACTER)
  19.             .withMappingStrategy(strategy)
  20.             .build();
  22.         List<Person> list = csvToBean.parse();
  24.         for (Person p : list) {
  25.             System.out.println(p.toString());
  26.         }
  27.         csvReader.close();
  28.         reader.close();
  29.     } catch (FileNotFoundException e) {
  30.         e.printStackTrace();
  31.     } catch (IOException e) {
  32.         e.printStackTrace();
  33.     }
  34. }

writeCsv

  1. public void writeCsv(List<Person> dataList, String finalPath) {
  2.     try {
  3.         Writer writer = new FileWriter(finalPath);
  5.         // 设置显示的顺序
  6.         String[] columnMapping = {"id", "name", "age"};
  7.         ColumnPositionMappingStrategy<Person> mapper =
  8.             new ColumnPositionMappingStrategy<>();
  9.         mapper.setType(Person.class);
  10.         mapper.setColumnMapping(columnMapping);
  12.         // 写表头
  13.         CSVWriter csvWriter = new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER, '\\', "\n");
  14.         String[] header = { "编号", "姓名", "年龄"};
  15.         csvWriter.writeNext(header);
  17.         StatefulBeanToCsv beanToCsv = new StatefulBeanToCsvBuilder(writer)
  18.             .withMappingStrategy(mapper)
  19.             .withQuotechar(CSVWriter.NO_QUOTE_CHARACTER)
  20.             .withSeparator(CSVWriter.DEFAULT_SEPARATOR)
  21.             .withEscapechar('\\')
  22.             .build();
  23.         beanToCsv.write(dataList);
  24.         csvWriter.close();
  25.         writer.close();
  26.     } catch (IOException e) {
  27.         e.printStackTrace();
  28.     } catch (CsvDataTypeMismatchException e) {
  29.         e.printStackTrace();
  30.     } catch (CsvRequiredFieldEmptyException e) {
  31.         e.printStackTrace();
  32.     }
  33.     System.out.println(finalPath + "数据导出成功");
  34. }

实体

  1. @Data
  2. @AllArgsConstructor
  3. @NoArgsConstructor
  4. public class Person {
  5.     private Integer id;
  6.     private String name;
  7.     private Integer age;
  8. }

测试类的方法（maven项目结构中的测试类）

finalPath 是绝对路径+文件名，请确保欲生成的文件所在目录已创建好。

  1. @Test
  2. void writeCsv() {
  3.     // test data
  4.     Person person0 = new Person(11, "钱多多", 18);
  5.     Person person1 = new Person(22, "王多鱼", 19);
  6.     Person person2 = new Person(33, "喜羊羊", 20);
  7.     List<Person> personList = new ArrayList<>();
  8.     personList.add(person0);
  9.     personList.add(person1);
  10.     personList.add(person2);
  12.     String finalPath = "/Users/qianshijie/Temporary/skycomm/devsyn/test.csv";
  14.     personService.writeCsv(personList, finalPath);
  15. }
  17. @Test
  18. void readCsv() {
  19.     String finalPath = "/Users/qianshijie/Temporary/skycomm/devsyn/test.csv";
  21.     personService.readCsv(finalPath);
  22. }

上述方法中，csv 文件的列名均已被替换（已不是实体类的属性名）。如果想让生成的 csv 文件列名和实体类属性名保持一致。请使用如下代码（只列举有变化的代码，未列出则代码无变动，变动已将原代码注释，以供对比）：

  1. public void writeCsv(List<Person> dataList, String finalPath) {
  2.     try {
  3.         Writer writer = new FileWriter(finalPath);
  5.         // 设置显示的顺序
  6.         String[] columnMapping = {"id", "name", "age"};
  7.         ColumnPositionMappingStrategy<Person> mapper =
  8.             new ColumnPositionMappingStrategy<>();
  9.         mapper.setType(Person.class);
  10.         mapper.setColumnMapping(columnMapping);
  12.         // 写表头
  13.         CSVWriter csvWriter = new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER, '\\', "\n");
  14.         // String[] header = { "编号", "姓名", "年龄"};
  15.         String[] header = { "id", "name", "age"};
  16.         csvWriter.writeNext(header);
  18.         StatefulBeanToCsv beanToCsv = new StatefulBeanToCsvBuilder(writer)
  19.             .withMappingStrategy(mapper)
  20.             .withQuotechar(CSVWriter.NO_QUOTE_CHARACTER)
  21.             .withSeparator(CSVWriter.DEFAULT_SEPARATOR)
  22.             .withEscapechar('\\')
  23.             .build();
  24.         beanToCsv.write(dataList);
  25.         csvWriter.close();
  26.         writer.close();
  27.     } catch (IOException e) {
  28.         e.printStackTrace();
  29.     } catch (CsvDataTypeMismatchException e) {
  30.         e.printStackTrace();
  31.     } catch (CsvRequiredFieldEmptyException e) {
  32.         e.printStackTrace();
  33.     }
  34.     System.out.println(finalPath + "数据导出成功");
  35. }
  1. public void readCsv(String finalPath) {
  2.     try {
  3.         Reader reader = new InputStreamReader(new FileInputStream(finalPath), StandardCharsets.UTF_8);
  4.         CSVReader csvReader = new CSVReaderBuilder(reader).build();
  6.         // 列名的映射
  7.         // HeaderColumnNameTranslateMappingStrategy<Person> strategy =
  8.         //         new HeaderColumnNameTranslateMappingStrategy<>();
  9.         // strategy.setType(Person.class);
  10.         // Map<String, String> columnMapping = new HashMap<>();
  11.         // columnMapping.put("编号", "id");
  12.         // columnMapping.put("姓名", "name");
  13.         // columnMapping.put("年龄", "age");
  14.         // strategy.setColumnMapping(columnMapping);
  16.         CsvToBean<Person> csvToBean = new CsvToBeanBuilder<Person>(csvReader)
  17.             .withSeparator(CSVWriter.DEFAULT_SEPARATOR)
  18.             .withQuoteChar(CSVWriter.NO_QUOTE_CHARACTER)
  19.             // .withMappingStrategy(strategy)
  20.             .withType(Person.class)
  21.             .build();
  23.         List<Person> list = csvToBean.parse();
  25.         for (Person p : list) {
  26.             System.out.println(p.toString());
  27.         }
  28.         csvReader.close();
  29.         reader.close();
  30.     } catch (FileNotFoundException e) {
  31.         e.printStackTrace();
  32.     } catch (IOException e) {
  33.         e.printStackTrace();
  34.     }
  35. }

中文乱码问题

  1. String filePath = "F:/test.csv";
  2. File file = new File(filePath);
  3. CSVReader csvReader = null;
  4. AccountLFFChannelDto accountLFFChannelDto = new AccountLFFChannelDto();
  5. DataInputStream in = new DataInputStream(new FileInputStream(file));
  6. csvReader = new CSVReader(new InputStreamReader(in,"gbk"));
  7. List<String[]> list = csvReader.readAll();
  8. .
  9. .
  10. . 以下代码省略。。。
  1.  @Test
  2.     public void readCsv() throws IOException, CsvException {
  3.         try {
  4.             String filePath = "/Users/jiadongpo/Downloads/【重要】加密数据/【保密】统一权限最新数据-20220517/ry.csv";
  5.             File file = new File(filePath);
  6.             DataInputStream in = new DataInputStream(new FileInputStream(file));
  7.             CSVReader csvReader = new CSVReader(new InputStreamReader(in, "gbk"));
  9.             String[] nextRecord;
  10.             while ((nextRecord = csvReader.readNext()) != null) {
  11.                 System.out.println(nextRecord[0]);
  12.                 System.out.println(nextRecord[1]);
  13.                 System.out.println(nextRecord[2]);
  14.                 System.out.println(nextRecord[3]);
  15.                 System.out.println(nextRecord[4]);
  16.                 System.out.println(nextRecord[5]);
  17.                 /*for (String cell : nextRecord) {
  18.                     System.out.print(cell + "\t");
  19.                 }*/
  20.                 System.out.println();
  21.             }
  22.         } catch (Exception e) {
  23.             e.printStackTrace();
  24.         }
  25.     }

跳过前几行

  1. CSVReader reader = new CSVReaderBuilder(inputStreamReader)
  2.                 .withFieldAsNull(CSVReaderNullFieldIndicator.EMPTY_SEPARATORS)
  3.                 // Skip the header
  4.                 .withSkipLines(1)
  5.                 .build();
  1. String filePath = "/Users/xxx/Downloads/10_230_21_200_389.csv";
  2.             File file = new File(filePath);
  3.             DataInputStream in = new DataInputStream(new FileInputStream(file));
  4.             CSVReader csvReader = new CSVReaderBuilder(new InputStreamReader(in, "gbk")).withFieldAsNull(CSVReaderNullFieldIndicator.EMPTY_SEPARATORS)
  5.                     // Skip the header
  6.                     .withSkipLines(3)
  7.                     .build();