java读取本地Excel文件,并返回list_swing读取固定位置下的excel文件并输出为list

1.写一个test测试方法

@Data
public static class Menu {
    @Id
    private Integer menuId;
    private String menuName;
    private String menuUrl;
    private Integer parentId;
    private Integer menuLevel;
    private Integer menuStatus;
    private String menuIcon;
    private Integer menuIndex;
}
@Test
    public void test(){
        File file = new File("C:\\Users\\picc\\Desktop\\gdwechat.xlsx");
        System.out.println(file.getName());//获取文件名称 gdwechat.xlsx
        List<Menu> all = new ArrayList<>();
        try(FileInputStream fileInputStream = new FileInputStream(file)){
            ExcelReader sheet1 = ExcelUtil.getReader(fileInputStream, "sheet1");
            System.out.println(sheet1);//cn.hutool.poi.excel.ExcelReader@28ec166e
            sheet1.addHeaderAlias("菜单id","menuId");
            sheet1.addHeaderAlias("菜单名称","menuName");
            sheet1.addHeaderAlias("菜单url","menuUrl");
            sheet1.addHeaderAlias("父菜单id","parentId");
            sheet1.addHeaderAlias("菜单级别","menuLevel");
            sheet1.addHeaderAlias("菜单状态","menuStatus");
            sheet1.addHeaderAlias("菜单icon","menuIcon");
            sheet1.addHeaderAlias("菜单排序","menuIndex");
            all = sheet1.readAll(Menu.class);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        /**
        *[Menu(menuId=1, menuName=首页, menuUrl=/home, parentId=null, menuLevel=0, menuStatus=1, menuIcon=iconfont icon-index, menuIndex=1, urlName=null)]
        */
        System.out.println(all);//打印读取的list数据
        System.out.println(all.size());//list条数 1
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

2.Excel文件格式

3.Menu实体类

package ins.platform.db.po.primary;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import javax.persistence.Id;
import javax.persistence.Table;
import java.util.List;

@Data
@Table(name="menu")
@AllArgsConstructor//全参构造器
@NoArgsConstructor//无参构造器
public class Menu {
    @Id
    private Integer menuId;
    private String menuName;
    private String menuUrl;
    private Integer parentId;
    private Integer menuLevel;
    private Integer menuStatus;
    private String menuIcon;
    private Integer menuIndex;
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

鼠标右键 ‘generate’