java使用EasyExcel导入导出excel

一、准备工作

1、导包

|

<!-- poi 相关-->

<``dependency``>

<``groupId``>org.apache.poi</``groupId``>

<``artifactId``>poi</``artifactId``>

<``version``>3.17</``version``>

</``dependency``>

<``dependency``>

<``groupId``>org.apache.poi</``groupId``>

<``artifactId``>poi-ooxml-schemas</``artifactId``>

<``version``>3.17</``version``>

</``dependency``>

<``dependency``>

<``groupId``>org.apache.poi</``groupId``>

<``artifactId``>poi-ooxml</``artifactId``>

<``version``>3.17</``version``>

</``dependency``>

<!-- esayexcel 2.1.7  -->

<``dependency``>

<``groupId``>com.alibaba</``groupId``>

<``artifactId``>easyexcel</``artifactId``>

<``version``>2.1.7</``version``>

</``dependency``>

|