java关于读取csv文件保存为list<hashmap<String,Object >>,头标题

pom.xml文件

<dependency>
            <groupId>net.sourceforge.javacsv</groupId>
            <artifactId>javacsv</artifactId>
            <version>2.0</version>
        </dependency>
<dependency>
            <groupId>commons-net</groupId>
            <artifactId>commons-net</artifactId>
            <version>3.3</version>
        </dependency>


        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-csv</artifactId>
            <version>1.4</version>
        </dependency>
import java.io.BufferedReader;
import java.io.FileReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

public class CsvTest {

    public static void main(String[] args) {
        String inpath="D:\\icos-20190715162055.csv";
        List<HashMap<String, Object>> retHashMap = new ArrayList<HashMap<String, Object>>();
        retHashMap = getcsvTableList(inpath);
        for(HashMap k:retHashMap) {
            System.out.println(k);
        }

    }
    public static List<HashMap<String, Object>> getcsvTableList(String path) {
        List<HashMap<String, Object>> retHashMap = new ArrayList<HashMap<String, Object>>();
        try {
            BufferedReader reader = new BufferedReader(new FileReader(path));
            String[] headtilte = reader.readLine().split("\\|");// 第一行信息,为标题信息,不用,如果需要,注释掉
            String line = null;
            while ((line = reader.readLine()) != null) {
                HashMap<String, Object> itemMap = new HashMap<String, Object>();
                String[] itemArray = line.split("\\|");
                for (int i = 0; i < itemArray.length; i++) {
                    itemMap.put(headtilte[i], itemArray[i]);
                }
                retHashMap.add(itemMap);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return retHashMap;
    }

}

 

posted on 2019-08-20 15:53  tanada  阅读(1427)  评论(0编辑  收藏  举报