org.apache.poi.hssf.usermodel.HSSFWorkbook.addPicture()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(8.7k)|赞(0)|评价(0)|浏览(258)

本文整理了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.addPicture()方法的一些代码示例，展示了HSSFWorkbook.addPicture()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。HSSFWorkbook.addPicture()方法的具体详情如下：
包路径：org.apache.poi.hssf.usermodel.HSSFWorkbook
类名称：HSSFWorkbook
方法名：addPicture

HSSFWorkbook.addPicture介绍

[英]Adds a picture to the workbook.
[中]将图片添加到工作簿中。

代码示例

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook workbook;        
  2. workbook.addPicture(pngData, HSSFWorkbook.PICTURE_TYPE_PNG);

代码示例来源：origin: youseries/ureport

  1. byte[] bytes=IOUtils.toByteArray(inputStream);
  2.   int pictureFormat=buildImageFormat(img);
  3.   int pictureIndex=wb.addPicture(bytes, pictureFormat);
  4.   anchor.setCol1(i);
  5.   anchor.setCol2(i+colSpan);
  6.     byte[] bytes=IOUtils.toByteArray(inputStream);
  7.     int pictureFormat=buildImageFormat(img);
  8.     int pictureIndex=wb.addPicture(bytes, pictureFormat);
  9.     anchor.setCol1(i);
  10.     anchor.setCol2(i+colSpan);
  11. byte[] bytes=IOUtils.toByteArray(inputStream);
  12. int pictureFormat=buildImageFormat(img);
  13. int pictureIndex=wb.addPicture(bytes, pictureFormat);
  14. anchor.setCol1(i);
  15. anchor.setCol2(i+colSpan);
  16.   byte[] bytes=IOUtils.toByteArray(inputStream);
  17.   int pictureFormat=buildImageFormat(img);
  18.   int pictureIndex=wb.addPicture(bytes, pictureFormat);
  19.   anchor.setCol1(i);
  20.   anchor.setCol2(i+colSpan);

代码示例来源：origin: org.apache.poi/poi-examples

  1. private static int loadPicture( String path, HSSFWorkbook wb ) throws IOException
  2. {
  3.   int pictureIndex;
  4.   FileInputStream fis = null;
  5.   ByteArrayOutputStream bos = null;
  6.   try
  7.   {
  8.     fis = new FileInputStream( path);
  9.     bos = new ByteArrayOutputStream( );
  10.     int c;
  11.     while ( (c = fis.read()) != -1)
  12.       bos.write( c );
  13.     pictureIndex = wb.addPicture( bos.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG );
  14.   }
  15.   finally
  16.   {
  17.     if (fis != null)
  18.       fis.close();
  19.     if (bos != null)
  20.       bos.close();
  21.   }
  22.   return pictureIndex;
  23. }

代码示例来源：origin: cuba-platform/yarg

  1. protected void copyPicturesToResultWorkbook() {
  2.   List<HSSFPictureData> allPictures = templateWorkbook.getAllPictures();
  3.   for (HSSFPictureData allPicture : allPictures) {
  4.     int i = resultWorkbook.addPicture(allPicture.getData(), Workbook.PICTURE_TYPE_JPEG);
  5.     orderedPicturesId.add(i);
  6.   }
  7. }

代码示例来源：origin: com.haulmont.yarg/yarg

  1. protected void copyPicturesToResultWorkbook() {
  2.   List<HSSFPictureData> allPictures = templateWorkbook.getAllPictures();
  3.   for (HSSFPictureData allPicture : allPictures) {
  4.     int i = resultWorkbook.addPicture(allPicture.getData(), Workbook.PICTURE_TYPE_JPEG);
  5.     orderedPicturesId.add(i);
  6.   }
  7. }

代码示例来源：origin: com.github.mg365/mg-common

  1. patriarch.createPicture(anchor, workBook.addPicture(bos.toByteArray(), workBook.PICTURE_TYPE_PNG));

代码示例来源：origin: com.github.mg365/mg-common

  1. private void createPicture(HSSFWorkbook workBook,MObjectExportVo exportVo,List<String> picturesList) throws IOException {
  2.   for (int i = 0; i < picturesList.size(); i++) {
  3.     HSSFSheet sheet = workBook.getSheetAt(i);
  4.     if(StringUtils.isBlank(picturesList.get(i))){
  5.       continue;
  6.     }
  7.     //String picture = "C:\\jira\\person.png";  //要插入的图片，可为png、jpg格式
  8.     String picture = PropertyConfigurer.getContextProperty("temppath") + picturesList.get(i);
  9.     ByteArrayOutputStream bos = new ByteArrayOutputStream();
  10.     BufferedImage BufferImg = ImageIO.read(new File(picture));
  11.     ImageIO.write(BufferImg, "PNG", bos);
  12.     HSSFPatriarch patriarch = sheet.createDrawingPatriarch();//创建绘图工具对象
  13.     int col1 = exportVo.getStartCol();  //起始单元格列序号；
  14.     int row1 = exportVo.getStartRow();  //起始单元格行序号;
  15.     int col2 = exportVo.getEndCol();    //终止单元格列序号；
  16.     int row2 = exportVo.getEndRow();    //终止单元格行序号；
  17.     HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short) col1, row1, (short) col2, row2);
  18.     patriarch.createPicture(anchor, workBook.addPicture(bos.toByteArray(), workBook.PICTURE_TYPE_PNG));
  19.   }
  20. }

代码示例来源：origin: com.dexcoder/dexcoder-commons

  1. /**
  2.  * 创建图片列
  3.  *
  4.  * @param workbook  工作薄
  5.  * @param sheet     sheet对象
  6.  * @param row       行对象
  7.  * @param rowIndex  行索引
  8.  * @param cellIndex 列索引
  9.  * @param value     列的值
  10.  */
  11. public void createPictureCellStyle(HSSFWorkbook workbook, HSSFSheet sheet, HSSFRow row, int rowIndex,
  12.                   int cellIndex, byte[] value) {
  13.   // 有图片时，设置行高为60px;
  14.   row.setHeightInPoints(60);
  15.   // 设置图片所在列宽度为80px,注意这里单位的一个换算
  16.   sheet.setColumnWidth(cellIndex, (int) (35.7 * 80));
  17.   HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255, (short) cellIndex, rowIndex, (short) cellIndex,
  18.     rowIndex);
  19.   anchor.setAnchorType(HSSFClientAnchor.MOVE_DONT_RESIZE);
  20.   HSSFPatriarch patriarch = sheet.getDrawingPatriarch();
  21.   patriarch.createPicture(anchor, workbook.addPicture(value, HSSFWorkbook.PICTURE_TYPE_JPEG));
  22. }

代码示例来源：origin: selfly/dexcoder-assistant

  1. /**
  2.  * 创建图片列
  3.  *
  4.  * @param workbook  工作薄
  5.  * @param sheet     sheet对象
  6.  * @param row       行对象
  7.  * @param rowIndex  行索引
  8.  * @param cellIndex 列索引
  9.  * @param value     列的值
  10.  */
  11. public void createPictureCellStyle(HSSFWorkbook workbook, HSSFSheet sheet, HSSFRow row, int rowIndex,
  12.                   int cellIndex, byte[] value) {
  13.   // 有图片时，设置行高为60px;
  14.   row.setHeightInPoints(60);
  15.   // 设置图片所在列宽度为80px,注意这里单位的一个换算
  16.   sheet.setColumnWidth(cellIndex, (int) (35.7 * 80));
  17.   HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1023, 255, (short) cellIndex, rowIndex, (short) cellIndex,
  18.     rowIndex);
  19.   anchor.setAnchorType(HSSFClientAnchor.MOVE_DONT_RESIZE);
  20.   HSSFPatriarch patriarch = sheet.getDrawingPatriarch();
  21.   patriarch.createPicture(anchor, workbook.addPicture(value, HSSFWorkbook.PICTURE_TYPE_JPEG));
  22. }

代码示例来源：origin: stackoverflow.com

  1. byte previewImg[] = IOUtils.toByteArray(is);
  2.   is.close();
  3.   int pictIdx = workbook.addPicture(previewImg, HSSFWorkbook.PICTURE_TYPE_PNG);
  4.   return pictIdx;
  5. } catch (IOException e) {

代码示例来源：origin: cuba-platform/yarg

  1. @Override
  2. public void inlineToXls(HSSFPatriarch patriarch, HSSFCell resultCell, Object paramValue, Matcher paramsMatcher) {
  3.   try {
  4.     Image image = new Image(paramValue, paramsMatcher);
  5.     if (image.isValid()) {
  6.       HSSFSheet sheet = resultCell.getSheet();
  7.       HSSFWorkbook workbook = sheet.getWorkbook();
  8.       int pictureIdx = workbook.addPicture(image.imageContent, Workbook.PICTURE_TYPE_JPEG);
  9.       CreationHelper helper = workbook.getCreationHelper();
  10.       ClientAnchor anchor = helper.createClientAnchor();
  11.       anchor.setCol1(resultCell.getColumnIndex());
  12.       anchor.setRow1(resultCell.getRowIndex());
  13.       anchor.setCol2(resultCell.getColumnIndex());
  14.       anchor.setRow2(resultCell.getRowIndex());
  15.       if (patriarch == null) {
  16.         throw new IllegalArgumentException(String.format("No HSSFPatriarch object provided. Charts on this sheet could cause this effect. Please check sheet %s", resultCell.getSheet().getSheetName()));
  17.       }
  18.       HSSFPicture picture = patriarch.createPicture(anchor, pictureIdx);
  19.       Dimension size = ImageUtils.getDimensionFromAnchor(picture);
  20.       double actualHeight = size.getHeight() / EMU_PER_PIXEL;
  21.       double actualWidth = size.getWidth() / EMU_PER_PIXEL;
  22.       picture.resize((double) image.width / actualWidth, (double) image.height / actualHeight);
  23.     }
  24.   } catch (IllegalArgumentException e) {
  25.     throw new ReportFormattingException("An error occurred while inserting bitmap to xls file", e);
  26.   }
  27. }

代码示例来源：origin: com.haulmont.yarg/yarg

  1. @Override
  2. public void inlineToXls(HSSFPatriarch patriarch, HSSFCell resultCell, Object paramValue, Matcher paramsMatcher) {
  3.   try {
  4.     Image image = new Image(paramValue, paramsMatcher);
  5.     if (image.isValid()) {
  6.       HSSFSheet sheet = resultCell.getSheet();
  7.       HSSFWorkbook workbook = sheet.getWorkbook();
  8.       int pictureIdx = workbook.addPicture(image.imageContent, Workbook.PICTURE_TYPE_JPEG);
  9.       CreationHelper helper = workbook.getCreationHelper();
  10.       ClientAnchor anchor = helper.createClientAnchor();
  11.       anchor.setCol1(resultCell.getColumnIndex());
  12.       anchor.setRow1(resultCell.getRowIndex());
  13.       anchor.setCol2(resultCell.getColumnIndex());
  14.       anchor.setRow2(resultCell.getRowIndex());
  15.       if (patriarch == null) {
  16.         throw new IllegalArgumentException(String.format("No HSSFPatriarch object provided. Charts on this sheet could cause this effect. Please check sheet %s", resultCell.getSheet().getSheetName()));
  17.       }
  18.       HSSFPicture picture = patriarch.createPicture(anchor, pictureIdx);
  19.       Dimension size = ImageUtils.getDimensionFromAnchor(picture);
  20.       double actualHeight = size.getHeight() / EMU_PER_PIXEL;
  21.       double actualWidth = size.getWidth() / EMU_PER_PIXEL;
  22.       picture.resize((double) image.width / actualWidth, (double) image.height / actualHeight);
  23.     }
  24.   } catch (IllegalArgumentException e) {
  25.     throw new ReportFormattingException("An error occurred while inserting bitmap to xls file", e);
  26.   }
  27. }

代码示例来源：origin: com.bstek.ureport/ureport2-core

  1. byte[] bytes=IOUtils.toByteArray(inputStream);
  2.   int pictureFormat=buildImageFormat(img);
  3.   int pictureIndex=wb.addPicture(bytes, pictureFormat);
  4.   anchor.setCol1(i);
  5.   anchor.setCol2(i+colSpan);
  6.     byte[] bytes=IOUtils.toByteArray(inputStream);
  7.     int pictureFormat=buildImageFormat(img);
  8.     int pictureIndex=wb.addPicture(bytes, pictureFormat);
  9.     anchor.setCol1(i);
  10.     anchor.setCol2(i+colSpan);
  11. byte[] bytes=IOUtils.toByteArray(inputStream);
  12. int pictureFormat=buildImageFormat(img);
  13. int pictureIndex=wb.addPicture(bytes, pictureFormat);
  14. anchor.setCol1(i);
  15. anchor.setCol2(i+colSpan);
  16.   byte[] bytes=IOUtils.toByteArray(inputStream);
  17.   int pictureFormat=buildImageFormat(img);
  18.   int pictureIndex=wb.addPicture(bytes, pictureFormat);
  19.   anchor.setCol1(i);
  20.   anchor.setCol2(i+colSpan);

代码示例来源：origin: jasperreports/jasperreports

  1. int imgIndex = workbook.addPicture(JRImageLoader.loadImageDataFromAWTImage(bi, JRRenderable.IMAGE_TYPE_PNG), HSSFWorkbook.PICTURE_TYPE_PNG);
  2. patriarch.createPicture(anchor, imgIndex);

代码示例来源：origin: org.apache.poi/poi-examples

  1. int index = sheet.getWorkbook().addPicture(this.imageToBytes(imageFile), HSSFWorkbook.PICTURE_TYPE_PNG);

内容来源于网络，如有侵权，请联系作者删除！

HSSFWorkbook

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    HSSFWorkbook类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com