java读取csv文件

最新推荐文章于 2024-11-04 22:26:34 发布

chulieju9954

最新推荐文章于 2024-11-04 22:26:34 发布

阅读量121

点赞数

文章标签： java

原文链接：https://my.oschina.net/u/193184/blog/912222

版权

1.添加maven依赖

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-csv</artifactId>
    <version>1.4</version>
</dependency>

2. 相关代码

public static List<CSVRecord> getcsvRecordListFromStr(String buff) throws IOException {
    ByteArrayInputStream tInputStringStream = new ByteArrayInputStream(buff.getBytes());
    Reader csvReader = new InputStreamReader(tInputStringStream, "UTF-8");
    CSVParser csvParser = new CSVParser(csvReader, CSVFormat.EXCEL.withHeader());
    List<CSVRecord> csvRecordList = csvParser.getRecords();
    return csvRecordList;
}

List<CSVRecord> records = CommonUtils.getcsvRecordListFromStr(buff);
records.remove(0);
for(CSVRecord record:records) {
    String settlementDay = record.get("结算日期\t").trim();

}

转载于:https://my.oschina.net/u/193184/blog/912222