EasyPoi应用以及部分源码解读

缺乏、安全感 2024-04-18 09:16 71阅读 0赞

**目录**

EasyPoi官网

EasyPoi应用

EasyPoi test代码

源码解读

导出代码

思路

权限控制

--------------------

# EasyPoi官网 #

[http://easypoi.mydoc.io][http_easypoi.mydoc.io]

# EasyPoi应用 #

[https://blog.csdn.net/justry\_deng/article/details/84842111][https_blog.csdn.net_justry_deng_article_details_84842111]

# EasyPoi test代码 #

[https://gitee.com/lemur/easypoi-test][https_gitee.com_lemur_easypoi-test]

# 源码解读 #

EasyPoi是根据反射（动态代理）完成的。

## 导出代码 ##

// 生成workbook 并导出
    Workbook workbook = ExcelExportUtil.exportExcel(exportParams, StudentVO.class, list);

创建sheet

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70][]

获取所有属性

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 1][]

包括父类的Field

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 2][]

获取实体get方法

private Map<String, Method> getMethods = new HashMap<String, Method>();

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 3][]

把实体类的方法getXX()函数保存起来，方便获取属性值xx.getMethod().invoke来获取属性值

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 4][]

生成excel

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 5][]

# 思路 #

获取实体注解上的属性，以及实体，父类的属性，还有getXX,setXX方法，获取数据，再使用传统的创建shell方法创建文件

# 权限控制 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 6][]

@Excel注解的属性，默认false都显示数据

参考[伊大大的文章][Link 1]

其中也是基于反射去注入这个属性，获取这个反射对象，再获取属性，属性上的注解，再获取代理，以及里面的属性，再注入isColumnHidden这个属性，nice

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 7][]

[http_easypoi.mydoc.io]: http://easypoi.mydoc.io/
[https_blog.csdn.net_justry_deng_article_details_84842111]: https://blog.csdn.net/justry_deng/article/details/84842111
[https_gitee.com_lemur_easypoi-test]: https://gitee.com/lemur/easypoi-test
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/291d1bd66cf348c8b00edd769b7a1688.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/26d8ecd759b1489b80a4ee081ed1f3ed.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/6223cd4ba7dd43f284f62e7479e07b83.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/24047a49b6254a688bfd74dbd68a4c8e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/0a1ceb4584994b11a703b5e79e81ca29.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/c10c058fb9a24f9d8de8c93061566843.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/c93dc82ad6384ce7ade742f43e7f56d7.png
[Link 1]: https://mp.weixin.qq.com/s?__biz=MzIwMDY0Nzk2Mw==&mid=2650320593&idx=1&sn=af7c3c6ee1eef13f7ad7dbf736e13c97&chksm=8ef5faa5b98273b3d9fafa1241e71b0a344a2566c5549e38cc0bfb3d52d6fbb1e9865328a9ce&mpshare=1&scene=2&srcid=0904kKzUI88ch52IbNJgjQEg&sharer_sharetime=1567573386692&sharer_shareid=2a6de52c25a6a3a0164993bffe122d8a&from=timeline&clicktime=1567583960#rd
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODMzNjY1OA_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/16fe8a4c7bb24b7983bd67ce7aa55a65.png