同样的,看你要导出的Excel后缀是xls格式还是xlsx格式,不同的格式代码稍微有些不同,下面是导出xlsx格式的Excel。
Maven:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.9</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.9</version>
</dependency>
Controller层:
/**
* 导出Excel
* @param pageable
* @param date
* @param response
* @throws IOException
*/
@GetMapping("test/export")
public void exportDormCheckScore(@PageableDefault(size = 1000000) Pageable pageable,