• 请不要在回答技术问题时复制粘贴 AI 生成的内容
e583409
V2EX  ›  程序员

读取 CSV 遇到乱码 大家有什么好的解决方案吗?

  •  
  •   e583409 · Oct 28, 2021 · 2669 views
    This topic created in 1849 days ago, the information mentioned may be changed or developed.
    读取 csv 真有点麻烦
    wps 导出的 csv 和 MS office 导出的 csv (有 2 种格式,一种是 UTF-8 CSV ,带 BOM ,另一种是逗号分隔的 CSV )都有点不兼容

    有没有比较好的 Java 解决方案,类似 easyexcel 工具,我现在用 common-csv ,谢谢
    6 replies  •  2023-09-27 17:21:27 +08:00
    gxm44
    gxm44
    Oct 28, 2021
    1
    你这里的“读取 CSV 遇到乱码”,是程序里读出来的 csv 是乱码?
    e583409
    e583409
    OP
    Oct 28, 2021
    2
    @gxm44 是的 debug 的时候 看到的
    e583409
    e583409
    OP
    Oct 28, 2021
    3
    BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath))));
    CSVParser parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    List<String> headers = parser.getHeaderNames();
    List<CSVRecord> dataList = parser.getRecords();

    br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath)), "GBK"));//"UTF-8"
    parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    headers = parser.getHeaderNames();
    dataList = parser.getRecords();

    br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath)), "UTF-8"));//"UTF-8"
    parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    headers = parser.getHeaderNames();
    dataList = parser.getRecords();
    SoloCompany
    SoloCompany
    Oct 28, 2021 via iPhone
    4
    bom detect 加 utf8 detect 加 gb18030 fallback
    e583409
    e583409
    OP
    Oct 30, 2021
    5
    @SoloCompany 谢谢 目前我是这样做的 只是觉得不够优雅 好像也么有其他办法了
    qiancheng
    qiancheng
    Sep 27, 2023
    6
    ```python
    BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath))));
    CSVParser parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    List<String> headers = parser.getHeaderNames();
    List<CSVRecord> dataList = parser.getRecords();

    br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath)), "GBK"));//"UTF-8"
    parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    headers = parser.getHeaderNames();
    dataList = parser.getRecords();

    br = new BufferedReader(new InputStreamReader(new FileInputStream(new File(filePath)), "UTF-8"));//"UTF-8"
    parser = CSVParser.parse(br, CSVFormat.EXCEL.builder().setHeader().setSkipHeaderRecord(true).build());
    headers = parser.getHeaderNames();
    dataList = parser.getRecords();
    ```
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   4290 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 33ms · UTC 08:25 · PVG 16:25 · LAX 00:25 · JFK 03:25
    ♥ Do have faith in what you're doing.