(这里写自定义目录标题)SpringBoot项目POI实现Excel表格的导入导出
POI的版本为4.0.0,网上查的资料大多都是POI3.12版本的,查了好多4.0.0版本的单元格样式,整理了一下。代码如下
pom.xml注入依赖
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-scratchpad</artifactId>
<version>4.0.0</version>
</dependency>
控制层导出代码
@RequestMapping(value = “/export”)
@ResponseBody
public void export(HttpServletResponse response) throws IOException {
List user =UserService.selectUser();
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet