java中Excel数据导入小Demo（超简单）

1.在pom.xml中导入依赖

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.9</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.9</version>
</dependency>

2.创建EXCEL表，添加数据

3.编写导入小demo

package com.test.base.test.excal;

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

public class ExcelTolead {


    public static void main(String[] args) throws IOException {
        System.out.println(getList());
    }

    public static List getList() throws IOException {
        //路径是刚刚创建的Excel的路径
        File filter =  new File("D:\\IDEA_WORK\\springCouldTest_base\\src\\main\\java\\com\\test\\excal\\Test.xlsx");
        Workbook wb = null;
        Sheet sheet = null;
        Row row = null;
        List list = null;
        String cellData = null;
        String columns[] = {"序号", "学生名称", "学生年龄", "学生性别"};
        FileInputStream is = new FileInputStream(filter);
        wb = new XSSFWorkbook(is);

        list = new ArrayList<Map<String, String>>();

        sheet = wb.getSheetAt(0);

        int rownum = sheet.getPhysicalNumberOfRows();

        row = sheet.getRow(0);

        int colnum = row.getPhysicalNumberOfCells();

        for (int i = 1; i < rownum; i++) {
            LinkedHashMap  map = new LinkedHashMap<>();
            row = sheet.getRow(i);
            if (row != null) {
                for (int j = 0; j < colnum; j++) {
                    cellData = String.valueOf(row.getCell(j));
                    map.put(columns[j], cellData);
                }
            } else {
                break;
            }
            list.add(map);
        }

        return list;
    }
}

4.运行测试结果

到此，已经OK了！！！