java导出图片到Excel

浅浅的花香味﹌ 2021-09-29 12:18 602阅读 0赞

<dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>3.17</version>
            </dependency>

package com.zpc.timor.test201907;
    
    import org.apache.poi.hssf.usermodel.*;
    import org.apache.poi.ss.usermodel.ClientAnchor;
    import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import javax.imageio.ImageIO;
    import javax.servlet.http.HttpServletResponse;
    import java.awt.image.BufferedImage;
    import java.io.ByteArrayOutputStream;
    import java.io.File;
    import java.io.IOException;
    import java.io.OutputStream;
    
    /**
     * @Author timor
     * @Date 2019/7/11
     */
    @Controller
    public class ExportExcelTest {
    
        @RequestMapping("/export")
        private static void export(HttpServletResponse response) throws IOException {
    
            HSSFWorkbook workbook = new HSSFWorkbook();
            // 生成一个表格
            HSSFSheet sheet = workbook.createSheet("title");
            HSSFRow row = sheet.createRow(0);
    //        HSSFCell cell = row.createCell(0);
    //        cell.setCellValue("123");
            File file = new File("D:/upload/file/9706a9fa-4d6d-4fd4-971f-0d5fc5645792.png");
            BufferedImage bufferedImage = ImageIO.read(file);
            ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
            ImageIO.write(bufferedImage, "jpg", byteArrayOut);
            byte[] data = byteArrayOut.toByteArray();
    
            HSSFPatriarch drawingPatriarch = sheet.createDrawingPatriarch();
            HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short)0, 0+2, (short) 1, 0 + 2);
            anchor.setAnchorType(ClientAnchor.AnchorType.byId(0));
            try {
                drawingPatriarch.createPicture(anchor, workbook.addPicture(data, XSSFWorkbook.PICTURE_TYPE_JPEG));
                OutputStream output = response.getOutputStream();
                response.reset();
                response.setHeader("Content-disposition",
                        "attachment; filename="+new String("员工表".getBytes("gbk"), "iso8859-1")+".xls");
                response.setContentType("application/msexcel");
                response.setCharacterEncoding("utf-8");
                workbook.write(output);
                output.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
    
        }
    
    
    }