1、引入依赖,用来生成excel
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.2</version>
</dependency>
2、接口类代码如下:
/**
* 企业列表--导出
*/
@ApiOperation("企业列表--导出")
@GetMapping(value = "/downloadTenantList")
public void downloadTenantList(HttpServletRequest request,
HttpServletResponse response) throws IOException {
log.info("downloadTenantList begin.");
String tenantIds = request.getParameter("tenantIds");
Map<String,String> map = tenantService.exportTenantListByIds(tenantIds);
String filePath = map.get("filePath");
String fileName = map.get("fileName");
InputStream is = new FileInputStream(new File(filePath));
// 设置response参数,可以打开下载页面
response.reset();
response.setContentType("application/octet-stream;charset=utf-8");
response.setHeader("Access-Control-Expose-Headers", "content-disposition");
response.setHeader("Content-Disposition", "attachment;filename="+fileName);
ServletOutputStream out = response.getOutputStream();
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
try {
bis = new BufferedInputStream(is);
bos = new BufferedOutputStream(out);
byte[] buff = new byte[2048];
int bytesRead;
while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
bos.write(buff, 0, bytesRead);
}
log.info("downloadTenantList end.");
} catch (final IOException e) {
log.error("downloadTenantList errors, reason:{}", e.getMessage());
} finally {
if (bis != null){
bis.close();
}
if (is != null){
is.close();
}
if (bos != null){
bos.close();
}
if (out != null){
out.close();
}
}
// 用后删除临时用途的文件
File fileTempZip = new File(filePath);
if(fileTempZip.exists()){
fileTempZip.delete();
}
}
3、服务层代码如下:
public Map<String,String> exportTenantListByIds(String ids) {
String[] idStrs = ids.split(",");
List<TenantMaintainDTO> list = tenantMapper.listTenantsByIds(Arrays.asList(idStrs));
List<TenantInfoExcelDTO> listExport = new ArrayList<>();
if(list!=null && !list.isEmpty()) {
// 处理企业相关信息,管理员、人数、企业行业、企业类型、企业规模
handleTenantRelatedInfo(list);
listExport = handleTenantListForExport(list);
}
String fileName = UuidUtil.getUuid() + ".xlsx";
String filePath = filePathTemp + fileName;
EasyExcel.write(filePath, TenantInfoExcelDTO.class)
.sheet("企业列表")
.doWrite(listExport);
Map<String,String> map = new HashMap<String,String>();
map.put("fileName",fileName);
map.put("filePath",filePath);
return map;
}
4、TenantInfoExcelDTO类代码如下:
package cn.iiot.myth.platform.dto.tenant;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
/**
* <pre>
* 企业列表
* </pre>
*
* @author heming@iiot.cn
* @date 2024-05-06
*/
@NoArgsConstructor
@AllArgsConstructor
@Data
@Builder
public class TenantInfoExcelDTO {
@ExcelProperty(value = "编号")
private String tenantId;
@ExcelProperty(value = "企业/组织机构名称")
private String companyName;
@ExcelProperty(value = "所属行业")
private String companyIndustry;
@ExcelProperty(value = "规模")
private String companyScale;
@ExcelProperty(value = "联系人")
private String contacts;
@ExcelProperty(value = "管理员")
private String managerNames;
@ExcelProperty(value = "平台成员数量")
private int userCount;
@ExcelProperty(value = "联系号码")
private String mobile;
@ExcelProperty(value = "联系邮箱")
private String email;
@ExcelProperty(value = "认证状态")
private String auditStatus;
@ExcelProperty(value = "入驻时间")
private Date createTime;
@ExcelProperty(value = "认证时间")
private Date joinDate;
}
5、前端使用window.open("接口路径");下载该excel文件。
功能正常使用,但是这种方式,前端加不了认证头信息,该后台接口不安全。
解决方案参考:后台接口返回void但是response有设置合适的相关信息,前端调用接口解析Blob数据下载excel文件-CSDN博客