Java 解析CSV和TXT

解析TXT

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

/**
     * TXT
     *
     * @param filePath
     * @throws
     */
    public List<String> readTxtFileByFileUtils(String filePath) throws Exception {
        List<String> resultList = new ArrayList<>();
        InputStream inputStream = null;
        LineIterator lineIterator = null;
        try {
            inputStream = new FileInputStream(filePath);
            lineIterator = IOUtils.lineIterator(inputStream, "UTF-8");
            while (lineIterator.hasNext()) {
                // 当前行的所有数据
                String line = lineIterator.nextLine();
                // 行数据以"|"分割
//                String[] txtData = line.split("\\|");
                resultList.add(line);
            }
            return resultList;
        } catch (IOException e) {
            throw new Exception(e);
        } finally {
            if (CollectionUtils.isNotEmpty(resultList)) {
                resultList.clear();
            }
            if (lineIterator != null) {
                try {
                    IOUtils.closeQuietly(inputStream);
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            }
            if (inputStream != null) {
                try {
                    inputStream.close();
                } catch (IOException e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }

解析CSV

    /**
     * 解析csv文件
     *
     * @param csvPath csv文件路径
     * @return 数组
     */
    public List<String[]> getCsvData(String csvPath) throws Exception {
        List<String[]> list = new ArrayList<>();
        try (CSVReader csvReader = new CSVReaderBuilder(new BufferedReader(
                new InputStreamReader(new FileInputStream(csvPath), StandardCharsets.UTF_8))).build()) {
            Iterator<String[]> iterator = csvReader.iterator();
            while (iterator.hasNext()) {
                String[] next = iterator.next();
                list.add(next);
            }
            return list;
        } catch (Exception e) {
            throw new Exception(e);
        }
    }