EasyPoi 导入导出

官方文档

表头自定义

public static void testExport() {
    try {
        List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
        entity.add(new ExcelExportEntity("姓名", "name"));
        entity.add(new ExcelExportEntity("性别", "sex"));
        entity.add(new ExcelExportEntity("职位", "title"));
        // list中元素是map，mybatis 返回类型可以设置为map
        List<Map<String, Object>> list = new ArrayList<>();
        Map<String, Object> map;
        for (int i = 0; i < 10; i++) {
            map = new HashMap<String, Object>();
            map.put("name", "1" + i);
            map.put("sex", "2" + i);

            List<Map<String, Object>> tempList = new ArrayList<Map<String, Object>>();
            tempList.add(map);
            tempList.add(map);
            map.put("students", tempList);

            list.add(map);
        }
        ExportParams exportParams = new ExportParams();
        exportParams.setSheetName("测试导出");
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, entity,
                list);
        FileOutputStream fos = new FileOutputStream("D:/ExcelExportForMap.tt.xls");
        workbook.write(fos);
        fos.close();
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
}