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();