目录

1、添加依赖

2、测试的csv文件

3、实际调用代码

 4、返回的数据格式

	net.sourceforge.javacsv
	javacsv
	2.0

2、测试的csv文件

3、实际调用代码

package com.shucha.deveiface.biz.test;

import com.csvreader.CsvReader;
import com.monitorjbl.xlsx.StreamingReader;
import com.sdy.common.model.BizException;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.xmlbeans.impl.xb.xsdschema.All;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class test2022 {
    public static void main(String[] args) throws BizException, IOException {
        File csvFile = new File("D:\123\测试csv.csv");
        readCsvByCsvReader(csvFile);
        readCsvByBufferedReader(csvFile.getPath());

    }

    public static Map readCsvByCsvReader(File file) {
        Map mapData = new HashMap<>();
        String fileName = file.getName();
        fileName = fileName.substring(0, fileName.lastIndexOf("."));
        mapData.put("sheetName",fileName);

        ArrayList strList = new ArrayList<>();
        List> list = new ArrayList<>();
        try {
            ArrayList arrList = new ArrayList();
            // 如果生产文件乱码，windows下用gbk，linux用UTF-8
            CsvReader reader = new CsvReader(file.getPath(), ',', Charset.forName("UTF-8"));
           // 读取表头
            reader.readHeaders();
            String[] headArray = reader.getHeaders();//获取标题
            // System.out.println(headArray);
            while (reader.readRecord()) {
                // System.out.println(Arrays.asList(reader.getValues()));
                // 按行读取，并把每一行的数据添加到list集合
                arrList.add(reader.getValues());
            }
            reader.close();
            // System.out.println("读取的行数：" + arrList.size());
            // 如果要返回 String[] 类型的 list 集合，则直接返回 arrList
            // 以下步骤是把 String[] 类型的 list 集合转化为 String 类型的 list 集合
            for (int i = 1; i < arrList.size(); i++) {
                // 组装String字符串
                // 如果不知道有多少列，则可再加一个循环
                Map map = new HashMap<>();
                for (int j=0;j readCsvByBufferedReader(String filePath) {
        File csv = new File(filePath);
        csv.setReadable(true);
        csv.setWritable(true);
        InputStreamReader isr = null;
        BufferedReader br = null;
        try {
            isr = new InputStreamReader(new FileInputStream(csv), "UTF-8");
            br = new BufferedReader(isr);
        } catch (Exception e) {
            e.printStackTrace();
        }
        String line = "";
        ArrayList records = new ArrayList<>();
        try {
            while ((line = br.readLine()) != null) {
                System.out.println(line);
                records.add(line);
            }
            System.out.println("csv表格读取行数：" + records.size());
        } catch (IOException e) {
            e.printStackTrace();
        }
        System.out.println(records);
        return records;
    }
}

 4、返回的数据格式

第一个方法返回数据：

{sheetName=测试csv, data=[{name=第1条数据, id=1, type=语文}, {name=第2条数据, id=2, type=数学}, {name=第3条数据, id=3, type=英语}, {name=第4条数据, id=4, type=美术}, {name=第5条数据, id=5, type=体育}, {name=第6条数据, id=6, type=}]}

第二个方法返回数据：

["id","name","type", "1","第1条数据","语文", "2","第2条数据","数学", "3","第3条数据","英语", "4","第4条数据","美术", "5","第5条数据","体育", "6","第6条数据",]