一、准备工作
1.将poi依赖导入到pom.xml
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.1</version>
</dependency>
二、前端查询出数据,直接在本页面调用后端接口,实现“下载”
1.点击导出数据按钮
<el-button type="success" icon="el-icon-bottom" size="mini" @click="exportEmps">导出数据</el-button>
2.在本页面调后端接口
exportEmps(){
window.open('/special/basic/export','_parent');
}
3.后端接口实现
@GetMapping("/export")
public ResponseEntity<byte[]> specialZoneExport(){
List<SpecialZone> spes= (List<SpecialZone>) specialZoneService.getAllSpecialZone(null, null, new SpecialZone(),null).getData();