poi 图片导出 excel

最新推荐文章于 2022-11-07 18:26:42 发布

原创最新推荐文章于 2022-11-07 18:26:42 发布 · 290 阅读

0 ·

CC 4.0 BY-SA版权

Java 同时被 2 个专栏收录

41 篇文章

订阅专栏

excel

2 篇文章

订阅专栏

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("sheet1");
// 不管你插入多少图片，都只要生成一个HSSFPatriarch 的对象
HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();

// 构建图片对象
BufferedImage image = GoogleBarCodeUtils.insertWords(GoogleBarCodeUtils.getBarCode("123"),  "123(**)");
ByteArrayOutputStream out = new ByteArrayOutputStream();
ImageIO.write(image, "jpeg", out);

for(int i = 0; i < 5; i++){
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255, (short) 1, i + 1, (short) 1, i + 1);
anchor.setAnchorType(ClientAnchor.AnchorType.byId(0));
patriarch.createPicture(anchor, wb.addPicture(out.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
} 
response.setContentType("application/octet-stream;charset=ISO8859-1");
response.setHeader("Content-Disposition", "attachment;filename=" + "**.xls");
response.addHeader("Pargam", "no-cache");
response.addHeader("Cache-Control", "no-cache");
OutputStream outs = response.getOutputStream();
wb.write(outs);
outs.close();