From 8d9286db8d1388019ffd326fc17f36f78080b594 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期六, 14 九月 2024 15:46:57 +0800
Subject: [PATCH] export device no
---
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
index b14a3ae..c259586 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java
@@ -85,4 +85,33 @@
log.error("瀵煎嚭{}寮傚父",sheetName,e);
}
}
+ public static void downloadExcelSheets(HttpServletResponse response, String fileName, String sheetName, List<Converter> list){
+ if(CollectionUtils.isEmpty(list)){
+ return;
+ }
+ /*try(ExcelWriter excelWriter = EasyExcel.write(file).build()) {
+ WriteSheet writeSheet;
+ for (SheetInfoBean bean : sheetInfoList) {
+ // 鏋勫缓sheet瀵硅薄
+ writeSheet = EasyExcel.writerSheet(bean.getSheetName()).head(bean.getHeadClass()).build();
+ // 鍐欏嚭sheet鏁版嵁
+ excelWriter.write(bean.getDataList(), writeSheet);
+ }
+ // 鍏虫祦
+ excelWriter.finish();
+ } catch (Exception e) {
+ // do something you want
+ }*/
+ try{
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setCharacterEncoding("utf-8");
+ fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
+ EasyExcel.write(response.getOutputStream(), list.get(0).getClass()).sheet(sheetName).doWrite(list);
+ }catch (Exception e){
+ log.error("瀵煎嚭{}寮傚父",sheetName,e);
+ }
+ }
+
+
}
\ No newline at end of file
--
Gitblit v1.8.0