EasyExcel导出图片

缺乏、安全感 2023-10-01 07:24 135阅读 0赞

在excel里导出图片：  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5YeJ5o6w5byA5rC0_size_20_color_FFFFFF_t_70_g_se_x_16]

### 1、数据实体 ###

import com.alibaba.excel.annotation.ExcelProperty;
    import com.alibaba.excel.annotation.write.style.*;
    import lombok.Data;
    import org.apache.poi.ss.usermodel.HorizontalAlignment;
    import org.apache.poi.ss.usermodel.VerticalAlignment;
    
    import java.net.URL;
    
    @Data
    @HeadRowHeight(25)
    @ContentRowHeight(120)
    public class ExcelDB {
        
    
        @ColumnWidth(35)
        @ExcelProperty(value = "规格")
        @ContentFontStyle(fontName = "Calibri", fontHeightInPoints = 12)
        @ContentStyle(wrapped = true, horizontalAlignment = HorizontalAlignment.CENTER,
                verticalAlignment = VerticalAlignment.CENTER)   // 自动换行、水平、垂直居中
        private String name;
    
        @ColumnWidth(35)
        @ExcelProperty("图片")
        private URL imgUrl;
    
        @ColumnWidth(35)
        @ExcelProperty(value = "介绍")
        @ContentFontStyle(fontName = "Calibri", fontHeightInPoints = 12)
        @ContentStyle(wrapped = true, horizontalAlignment = HorizontalAlignment.CENTER,
                verticalAlignment = VerticalAlignment.CENTER)   // 自动换行、水平、垂直居中
        private String introduce;
    
    }

### 2、web中下载 ###

import com.alibaba.excel.EasyExcel;
    import com.example.demo02.entity.ExcelDB;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import javax.servlet.http.HttpServletResponse;
    import java.io.IOException;
    import java.net.MalformedURLException;
    import java.net.URL;
    import java.util.ArrayList;
    import java.util.List;
    
    @RestController
    @RequestMapping("/excel")
    public class ExcelController {
        
    
        @PostMapping("exportExcel")
        public void exportExcel(HttpServletResponse response){
        
            List<ExcelDB> excelDBS = new ArrayList<>();
            // 测试数据
            ExcelDB excelDB = new ExcelDB();
            excelDB.setName("数据1");
            excelDB.setIntroduce("数据介绍");
            try {
        
                excelDB.setImgUrl(new URL("http://www.baidu.com/img/bdlogo.png"));
            } catch (MalformedURLException e) {
        
                e.printStackTrace();
            }
            excelDBS.add(excelDB);
    
            // 请求头设置
            response.setHeader("Content-Disposition", "attachment;filename=" + "XXXXX.xlsx");
            response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            response.setDateHeader("Expires", 0);
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "octets-stream");
            try {
        
                EasyExcel.write(response.getOutputStream(), ExcelDB.class).sheet("模板").doWrite(excelDBS);
            } catch (IOException e) {
        
                e.printStackTrace();
            }
        }
        
    }

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5YeJ5o6w5byA5rC0_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/5af5842c20134354b74e052c890553c1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5YeJ5o6w5byA5rC0,size_20,color_FFFFFF,t_70,g_se,x_16