• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

Java HSSFPicture类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了Java中org.apache.poi.hssf.usermodel.HSSFPicture的典型用法代码示例。如果您正苦于以下问题:Java HSSFPicture类的具体用法?Java HSSFPicture怎么用?Java HSSFPicture使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



HSSFPicture类属于org.apache.poi.hssf.usermodel包,在下文中一共展示了HSSFPicture类的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: getSheetPictrues03

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
/**
 * 获取Excel2003图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引(1_1)String,value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues03(HSSFSheet sheet,
                                                          HSSFWorkbook workbook) {
    Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
    List<HSSFPictureData> pictures = workbook.getAllPictures();
    if (!pictures.isEmpty()) {
        for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
            HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();
            if (shape instanceof HSSFPicture) {
                HSSFPicture pic = (HSSFPicture) shape;
                int pictureIndex = pic.getPictureIndex() - 1;
                HSSFPictureData picData = pictures.get(pictureIndex);
                String picIndex = String.valueOf(anchor.getRow1()) + "_"
                                  + String.valueOf(anchor.getCol1());
                sheetIndexPicMap.put(picIndex, picData);
            }
        }
        return sheetIndexPicMap;
    } else {
        return sheetIndexPicMap;
    }
}
 
开发者ID:rushingpig,项目名称:poix,代码行数:31,代码来源:PoiPublicUtil.java


示例2: getSheetPictrues03

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
/**
 * 获取Excel2003图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引(1_1)String,value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues03(HSSFSheet sheet, HSSFWorkbook workbook) {
    Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
    List<HSSFPictureData> pictures = workbook.getAllPictures();
    if (!pictures.isEmpty()) {
        for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {
            HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();
            if (shape instanceof HSSFPicture) {
                HSSFPicture pic = (HSSFPicture) shape;
                int pictureIndex = pic.getPictureIndex() - 1;
                HSSFPictureData picData = pictures.get(pictureIndex);
                String picIndex = String.valueOf(anchor.getRow1()) + "_"
                                  + String.valueOf(anchor.getCol1());
                sheetIndexPicMap.put(picIndex, picData);
            }
        }
        return sheetIndexPicMap;
    } else {
        return null;
    }
}
 
开发者ID:xiaolanglang,项目名称:easypoi,代码行数:30,代码来源:PoiPublicUtil.java


示例3: readAllCellImages

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
private static Table<Integer, Integer, ImageData> readAllCellImages(HSSFPatriarch patriarch, Sheet sheet) {
    val images = HashBasedTable.<Integer, Integer, ImageData>create();
    val allPictures = sheet.getWorkbook().getAllPictures();
    for (val shape : patriarch.getChildren()) {
        if (!(shape instanceof HSSFPicture && shape.getAnchor() instanceof HSSFClientAnchor)) continue;

        val picture = (HSSFPicture) shape;
        val imageData = createImageData(allPictures.get(picture.getPictureIndex() - 1));

        val axisRow = computeAxisRowIndex(sheet, picture);
        val axisCol = computeAxisColIndex(sheet, picture);

        images.put(axisRow, axisCol, imageData);
    }

    return images;
}
 
开发者ID:bingoohuang,项目名称:excel2javabeans,代码行数:18,代码来源:ExcelImages.java


示例4: processSheetImage

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
private void processSheetImage(Element htmlBody, HSSFSheet sheet) {
//        Element h2 = htmlDocumentFacade.createImage(logo);
//        h2.setAttribute("style", "top:112px;left:300px;position:absolute");
//        htmlBody.appendChild( h2 );

        if (sheet.getDrawingPatriarch() != null) {
            final List<HSSFShape> shapes = sheet.getDrawingPatriarch()
                    .getChildren();
            for (int i = 0; i < shapes.size(); ++i) {
                if (shapes.get(i) instanceof HSSFPicture) {
                    try {
                        // Gain access to private field anchor.
                        final HSSFPicture pic = (HSSFPicture) shapes.get(i);
                        picMap.put(pic.getPreferredSize().getCol1()+":"+pic.getPreferredSize().getRow1(), pic);
                    } catch (final Exception e) {
                        throw new RuntimeException(e);
                    }
                }
            }
        }
	}
 
开发者ID:rmage,项目名称:gnvc-ims,代码行数:22,代码来源:ExcelToHtmlConverter.java


示例5: setImage

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
private void setImage(final HSSFWorkbook workbook, final HSSFSheet sheet, final CellLocation cellLocation, int width, int height) {
    POIUtils.setCellValue(sheet, cellLocation, "");

    if (imageBuffer != null) {
        final HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

        final HSSFPicture picture = patriarch.createPicture(new HSSFClientAnchor(), pictureIndex);

        final Dimension dimension = picture.getImageDimension();
        final float rate = (float) dimension.width / (float) dimension.height;
        final float specifiedRate = (float) width / (float) height;

        if (width == -1 || height == -1) {
            width = dimension.width;
            height = dimension.height;

        } else {
            if (rate > specifiedRate) {
                if (dimension.width > width) {
                    height = (int) (width / rate);

                } else {
                    width = dimension.width;
                    height = dimension.height;
                }

            } else {
                if (dimension.height > height) {
                    width = (int) (height * rate);

                } else {
                    width = dimension.width;
                    height = dimension.height;
                }
            }
        }

        final HSSFClientAnchor preferredSize = getPreferredSize(sheet, new HSSFClientAnchor(0, 0, 0, 0, (short) cellLocation.c, cellLocation.r, (short) 0, 0), width, height);
        picture.setAnchor(preferredSize);
    }
}
 
开发者ID:roundrop,项目名称:ermasterr,代码行数:42,代码来源:PictureSheetGenerator.java


示例6: setImage

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
private void setImage(HSSFWorkbook workbook, HSSFSheet sheet,
		CellLocation cellLocation, int width, int height) {
	POIUtils.setCellValue(sheet, cellLocation, "");

	if (this.imageBuffer != null) {
		HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

		HSSFPicture picture = patriarch.createPicture(
				new HSSFClientAnchor(), this.pictureIndex);

		Dimension dimension = picture.getImageDimension();
		float rate = (float) dimension.width / (float) dimension.height;
		float specifiedRate = (float) width / (float) height;

		if (width == -1 || height == -1) {
			width = dimension.width;
			height = dimension.height;
			
		} else {
			if (rate > specifiedRate) {
				if (dimension.width > width) {
					height = (int) (width / rate);

				} else {
					width = dimension.width;
					height = dimension.height;
				}

			} else {
				if (dimension.height > height) {
					width = (int) (height * rate);

				} else {
					width = dimension.width;
					height = dimension.height;
				}
			}
		}

		HSSFClientAnchor preferredSize = this.getPreferredSize(sheet,
				new HSSFClientAnchor(0, 0, 0, 0, (short) cellLocation.c,
						cellLocation.r, (short) 0, 0), width, height);
		picture.setAnchor(preferredSize);
	}
}
 
开发者ID:kozake,项目名称:ermaster-k,代码行数:46,代码来源:PictureSheetGenerator.java


示例7: table

import org.apache.poi.hssf.usermodel.HSSFPicture; //导入依赖的package包/类
private void table(final HSSFSheet sheet) {
    if (sheet == null) {
        return;
    }
    if (sheet.getDrawingPatriarch() != null) {
        final List<HSSFShape> shapes = sheet.getDrawingPatriarch()
                .getChildren();
        for (int i = 0; i < shapes.size(); ++i) {
            if (shapes.get(i) instanceof HSSFPicture) {
                try {
                    // Gain access to private field anchor.
                    final HSSFShape pic = shapes.get(i);
                    final Field f = HSSFShape.class
                            .getDeclaredField("anchor");
                    f.setAccessible(true);
                    final HSSFClientAnchor anchor = (HSSFClientAnchor) f
                            .get(pic);
                    // Store picture cell row, column and picture data.
                    if (!pix.containsKey(anchor.getRow1())) {
                        pix.put(anchor.getRow1(),
                                new HashMap<Short, List<HSSFPictureData>>());
                    }
                    if (!pix.get(anchor.getRow1()).containsKey(
                            anchor.getCol1())) {
                        pix.get(anchor.getRow1()).put(anchor.getCol1(),
                                new ArrayList<HSSFPictureData>());
                    }
                    pix.get(anchor.getRow1())
                            .get(anchor.getCol1())
                            .add(book.getAllPictures().get(
                                    ((HSSFPicture) pic).getPictureIndex()));
                } catch (final Exception e) {
                    throw new RuntimeException(e);
                }
            }
        }
    }

    out.append("<table cellspacing='0' style='border-spacing:0; border-collapse:collapse;'>\n");
    for (rowIndex = 0; rowIndex < sheet.getPhysicalNumberOfRows(); ++rowIndex) {
        tr(sheet.getRow(rowIndex));
    }
    out.append("</table>\n");
}
 
开发者ID:NCIP,项目名称:nci-term-browser,代码行数:45,代码来源:ResolvedValueSetIteratorHolder.java



注:本文中的org.apache.poi.hssf.usermodel.HSSFPicture类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
Java Instruction20t类代码示例发布时间:2022-05-22
下一篇:
Java OnCheckedChangeListener类代码示例发布时间:2022-05-22
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap