From cf43493d7aa9c1a83cb1551c102f501f1dfde9b0 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期六, 06 六月 2020 13:23:39 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/MatCodeController.java | 9 +++++++-- 1 files changed, 7 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/MatCodeController.java b/src/main/java/com/zy/asrs/controller/MatCodeController.java index b36c779..00bb494 100644 --- a/src/main/java/com/zy/asrs/controller/MatCodeController.java +++ b/src/main/java/com/zy/asrs/controller/MatCodeController.java @@ -1,6 +1,7 @@ package com.zy.asrs.controller; import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; @@ -101,6 +102,7 @@ // 瀵煎嚭 @RequestMapping(value = "/matCode/export/auth") + @ManagerAuth(value = ManagerAuth.Auth.NONE, memo = "鐗╂枡缂栫爜鏁版嵁瀵煎嚭") public void export(@RequestParam(required = false) String fileName, @RequestParam(required = false) Integer rowCount, HttpServletResponse response) throws Exception { @@ -122,12 +124,15 @@ response.setCharacterEncoding("utf-8"); fileName = URLEncoder.encode(Cools.isEmpty(fileName)?"鐗╂枡缂栫爜":fileName, "UTF-8"); response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); - EasyExcel.write(response.getOutputStream(), MatCodeExcel.class).sheet("琛�1").doWrite(excels); + EasyExcel.write(response.getOutputStream(), MatCodeExcel.class) + .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) + .sheet("琛�1") + .doWrite(excels); } // 瀵煎叆 @RequestMapping(value = "/matCode/import/auth") - @ManagerAuth + @ManagerAuth(memo = "鐗╂枡缂栫爜鏁版嵁瀵煎叆") public R matCodeImport(MultipartFile file) throws IOException, InterruptedException { Thread.sleep(2000); EasyExcel.read(file.getInputStream(), MatCodeExcel.class, new MatCodeExcelListener()).sheet().doRead(); -- Gitblit v1.9.1