easyPOI初级使用

桃扇骨 2021-09-20 17:20 589阅读 0赞

### easyPOI初级使用 ###

*  环境 idea
 *  excl导入导出
 *   *  修改注解
     *  导入
 *  word模板导出
 *   *  插入链接与图片

# 环境 idea #

核心依赖

<dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-spring-boot-starter</artifactId>
                <version>4.0.0</version>
            </dependency>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70]

# excl导入导出 #

通过实体+注解的方式导出模板(结果)  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70 1]

@GetMapping("/down")
    public void down(HttpServletResponse httpServletResponse) { 
        String fileName = "导出模板.xls";
        Class clazz = AnnotationUtils.changeAnnotation(Person.class, new ArrayList<>());
        ExcelUtiles.exportExcel(new ArrayList<>(), "标题", "sheetName", clazz, LocalDateTime.now() + fileName, httpServletResponse);
    }

## 修改注解 ##

public static <T> Class changeAnnotation(Class<T> clazz, List<String> hideList) { 
        Field[] fields = clazz.getDeclaredFields();
        if (fields == null || fields.length < 1) { 
            return clazz;
        }
        for (Field field : fields) { 
            Excel excel = field.getAnnotation(Excel.class);
                InvocationHandler invocationHandler = Proxy.getInvocationHandler(excel);
                Field declaredField = null;
                try { 
                    declaredField = invocationHandler.getClass().getDeclaredField("memberValues");
                } catch (NoSuchFieldException e) { 
                    e.printStackTrace();
                }
                // 因为这个字段事 private final 修饰，所以要打开权限
                declaredField.setAccessible(true);
                // 获取 memberValues
                Map memberValues = null;
                try { 
                    memberValues = (Map) declaredField.get(invocationHandler);
                } catch (IllegalAccessException e) { 
                    e.printStackTrace();
                }
            if (hideList.indexOf(excel.name()) != -1) { 
                // 修改 value 属性值
                memberValues.put("isColumnHidden", true);
                System.out.println(excel.isColumnHidden());
            }else { 
                memberValues.put("isColumnHidden", false);
            }
        }
        return clazz;
    }

通过修改注解属性选怎动态导入导出行

## 导入 ##

/** * easypoi 导入 * * @param multipartFile * @return */
    @PostMapping("/imp")
    public String import1(@RequestBody MultipartFile multipartFile) { 
        List<Person> people = ExcelUtiles.importExcel(multipartFile, 1, 1, Person.class);
        System.out.println(people.size());
        return people.toString();
    }

# word模板导出 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70 2]

## 插入链接与图片 ##

链接: [git地址 demo][git_ demo]  
链接: [git地址 test][git_ test]

图片: ![Alt][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70]: /images/20210920/3689618015324021a0dfcc174093a7ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70 1]: /images/20210920/fd5df5228e7e448185755634ece6aa2f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyOTAzNjc3_size_16_color_FFFFFF_t_70 2]: /images/20210920/6271a83c1e4d4f6fb8b218b7a7d3474b.png
[git_ demo]: https://github.com/wujiawei1207537021/easypoi-demo
[git_ test]: https://gitee.com/lemur/easypoi-test.git
[Alt]: /images/20210920/db0d64ecded745fbbe0f324cd9300d99.png