导出

@GetMapping("/equDateDownExcelAng")
@ApiOperation("设备数据导出")
public void downExcel(HttpServletResponse response) throws IOException {
    response.setContentType("appliation/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    response.setCharacterEncoding("utf-8");
    String fileName = URLEncoder.encode("设备数据", "utf-8").replaceAll("\\+", "%20");
    response.setHeader("Content-disposition","attachment;filename*=utf-8''"+fileName+".xlsx");
    EasyExcel.write(response.getOutputStream(), EquData.class).sheet("记录").doWrite(service.getAll());
}
posted @ 2024-06-26 09:30  launch  阅读(30)  评论(0)    收藏  举报