用途:1.导出数据
2.信息导入到数据库(从excele到sql)
所需要知道的几个类(03和07的区别,行数有上限,03的为65535,07理论无上限)
HSSF==03版本的Excel
XSSF==07版本的EXCEL
HWPF==操作word
HSLF==POWERpoint
HDGF==vdsio
关于依赖
03
<!-- https://mvnrepository.com/artifact/poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.9</version>
</dependency>
关于07
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
数据库依赖
<!-- https://